Forum Discussion
Separating data in a single column
I have data exported from a ticketing/retails system which lumps all the items purchased by each customer in one column, with values separated by commas. There's potentially 100 different items they...
PQ indeed seems to be right tool for this. Can you share some example data, perhaps 20 rows of transactions and indicate how that should be summarised.
Save your file to OneDrive (or similar) and post a link that gives access to it here.