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...
Trying to analyze secondary purchases by ticket type. I’ve split items into columns, but ideally want each ticket type in its own column for easier filtering. Needs to be automatable monthly—feels like a PowerQuery task, but I’m new to it.https://wattsbuilt.com/