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