Combine Rows Based On ID

[jo15765]

I have a worksheet where in column J an employeeID is listed, and in column B the items sold for that day are. I want to take all the items for each employeeID and list on one line seperated with a comma.

For example if data looks like this
shirt e11
pants e11
socks e11
hat r33
blouse r33

I want a new worksheet to show the data like this
shirt, pants, socks e11
hat, blouse r33


This is for Excel 2013

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[jo15765]

Very close -- it copies it to a new worksheet, but each ID gets a new row, not each item on one row

And an extra comma at the end of the list (not a game changer on that)

[JOHN H. DAVIS]

I'm confused. Can you provide sample sheets. One before, and one after.

[jo15765]

worksheet showing how data is, and how data should be formatted.

[AB33]

Try the attached.

[jo15765]

Perfect, thank you!

[mike7952]

Give this a try

Please Login or Register  to view this content.

[daboho]

Mike 7952 : its good idea use dict

[mike7952]

@daboho
Why is that?