I've got a spreadsheet with data like this:
Product | Attribute ----------+---------- Product A | Cyan Product B | Cyan Product C | Cyan Product A | Magenta Product C | Magenta Product B | Yellow Product C | Yellow Product A | Black Product B | Black
What I'd like to do group everything by Column A and have Column B be a comma-delimited list of values that share Column A in common, like so:
Product | Attribute ----------+-------------------------- Product A | Cyan,Magenta,Black Product B | Cyan,Yellow,Black Product C | Cyan,Magenta,Yellow,Black
Unfortunately, Pivot Tables only know how to work with number values, and the furthest it goes towards this is counting the number of times Column A occurs.
I was able to pull this off ultimately by importing the data into a MySQL database and using MySQL's GROUP_CONCAT(Attribute)
function in a query with a GROUP BY Product
clause, but after banging my head on my desk repeatedly while attempting to figure out an Excel solution.
For future reference, is this possible in Excel without macros? Whether it is or not, how would one pull this off?