Hi Everyone -
I have an problem that I haven't been able to figure out and I'm hoping someone can help. I have an excel file with roughly 200K+ rows. I'm trying to run a pivot on the data to understand what upgrades customers have purchased. The column which shows the upgrades is comma delimited where the data is in the following format:
upgrade 1 | upgrade 2 | upgrade 3
upgrade 2 | Upgrade 3
I initially tried running a text 2 columns then using a pivot table, but the data comes out extremely messy. I then tried to just not use text to columns, but then the data is at an aggregated level where it isn't counting each unique occurrence ( for example, upgrade 1 should be counted 2x in the above example - not once).
Is there a way to use text to columns and use a pivot table? If not, what other options can I use?