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
Bookmarks