I have a table with categorical data - some data points have just one categorical data point and others have multiple. Can I create a Pivot Table that tabulates each data point individually? In order to do this, is there a way to separate the data points in the column so Excel knows where one data point ends and the next starts - I'm currently using spaces (e.g. "I2b E4c" : I want Excel to read this as one data point for "I2b" and one data point for "E4c", rather than one data point for "I2b E4c").
Solved by D. F. in 20 mins