Hi,

I'm trying to figure out the best way to analyze a set of data I have. A pivot should do just fine, but the problem is that I have multiple results in some cells. For example, I have a column to mark which pies a person mentions in a tweet. A person mentions pecan and pumpkin, and they are entered into the one cell separated by a comma. How do you recommend handling that for a data set of a few hundred rows, ten columns and most columns have the option for multiple answers per cell?

This is my first post, so please be gentle. Thank you!
pivotquestion.xlsx