I am keying some data and one question from the data set supports multiple answers. As best I can tell, I have the choice of keying this as a delimited column, e.g.
Answer1 ------ A A,B C B,D
Or, I can key it as multiple columns:
Answer1 Answer1 ------- ------- A A B C B D
Either way, I need to be able to summarize this data using a pivot table, but I'm not sure how to go about this? Suggestions?
The resulting pivot table should look something like:
Answer1 Count ------- ----- A 2 B 2 C 1 D 1