Excel - pivot values in one cell (as comma-separated value)
I have two columns of data:
Supplier1|Product1 Supplier1|Product2 Supplier1|Product4 Supplier1|Product7 Supplier2|Product3 Supplier2|Product5
I want to 'pivot' around Supplier, and give the list of products in one single cell, comma-separated e.g.
There's about 1000 suppliers, and 0 < products <= 10.
My current workaround involves using pivot tables, saving as CSV etc and is very messy. A non-VBA solution would be amazing.