Merging multiple cells into a single cell with comma

Hi All,

I have a requirement where , for each unique value in Col1, i have to merge a number of cells in Col2 together into a single cell with values seperated by comma. I have attached my sample Input sheet and how i want my Output to look. Any help would be appreciated.

Regards,
Faizan

Output in new sheet.

a little bit different

Please Login or Register  to view this content.