Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I have a set of data in excel with 2 or more columns. Lets assume 2 columns for the sake of simplicity. One column has a "title" and the other has "keywords". moultiple keywords can correspond to the same title. How can I combine rows with similar titles and merge the keywords for these rows with a delimiter like comma "," Example: TITLES KEYWORDS hello sunday hello monday congratualtions tuesday congratulations wednesday Result should look like -------------------------- TITLES KEYWORDS hello sunday,monday congratulations tuesday,wednesday In my case all similar titles are arranged one after the other. Thank you, Shailesh |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Minimizing Rows of with similar data | New Users to Excel | |||
Combining rows with similar data | Excel Discussion (Misc queries) | |||
How do I merge similar data across different excel worksheets? | Excel Discussion (Misc queries) | |||
How do I compare similar rows of data in same worksheet | Excel Worksheet Functions | |||
Shading rows of with similar data | Excel Programming |