Combine data in cell withn Comma Separator

[Parth007]

Hello Team,

Can you please suggest in making the data as per attached sheet

Macro should be build to show the column1 data with comma separator against the each name given in column8
For Example: Refer Output2 sheet in excel.

Thank you

[karedog]

Maybe :

Please Login or Register  to view this content.

[StephenR]

Slightly different approach (which I'm only posting because I wrote it before seeing karedog's solution)

Please Login or Register  to view this content.

[Parth007]

Simply Superb & Quick too .. Thanks Karedog & Stephen........ both worked fantastic thank you verymuch

[karedog]

You are welcome, and thanks for rep. points.


Regards