Excel - pivot values in one cell (as comma-separated value)
- by Chris
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.
Supplier1|Product1,Product2,Product4,Product7
Supplier2|Product3,Product5
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.