Hi guys,

I have a spreadsheet called Geiss catalogue which has approx 22000 part numbers in column A, it then has the corressponding machine that the part number goes to in Column B

some part numbers are duplicated meaning they can go to multiple machines.

I was hoping to show only the 1 part number in column A, and then the machine numbers in column B (if there are more than 1 can they be concatenated into the cell)

Current layout
2017-06-21_09-49-47.jpg

Proposed new layout

2017-06-21_09-51-05.jpg

I have attached a powerpoint and the spreadhsheet for reference.

Thanks