View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Shailesh Gattewar Shailesh Gattewar is offline
external usenet poster
 
Posts: 1
Default Merge rows with similar data

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