How to create a pivot table on a field with multiple answers per cell?

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

Thanks! The goal is to look at the correlations between the answers in each column, relative to date. So one example would be to get the number of mentions of each kind of pie by day. Does that help?

So would that mean duplicating each row as well? My concern is that several columns have been 10-20 different options.

Thanks! I think I understand, I'm going to try implementing and see how it goes.