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
Bookmarks