I hope I can explain myself correctly so I can get the correct solution from you all. We have made a poll to the students of the university I work at. We want to create a chart and a pivot table with the data. Thing is, not all our answers are entirely straight-forward and some have multiple choice. I hope this image can help you understand how the data looks like in my table:
0b407750ae3c30b86c32990b1ea66a0c.png
Now, as you can see, I have some combined cells describing the general topic, then I have the question, and then the possible answers, in some cases there's one question with just one answer (as in personal data) and in some cases I have one question with 2 or more possible answers. Now, take into consideration that this image shown is NOT the actual poll or size of the poll, I stretch out to 62 columns with data. How in the world can I creat a pivot table that can help me see the answers by clasification and the amount of answers for each of the specific questions so that I can then create a chart using the pivot table?
I hope you guys can help me out, I DO need all the columns names, meaning I can't just use the line with the specific questions.
Bookmarks