Analysing large amounts of data in excel using pivot table, not working correctly

Hello,

I am trying to create a pivot table from data that I have collected from a group questionnaire, there is 40 questions. Each question has about 5 different answer options. Every time I go to create the table it adds all the answers up to give me a total of people that answer. I already have this information. I have changed the values to count but it still adds the total which is not what I want. I want to see each individual answer!

I would be very grateful if anyone could help me

This has also been posted on other forums
https://www.excelguru.ca/forums/show...-a-pivot-table
Also MrExcel but the website has seemed to of crashed, but will upload the link when it re-loads

Megan

Thanks for amending the thread title.

Hi Megan,

Drag the answer (1-5) column head to the "Columns" box in the Pivot Table List. This will create separate columns for each answer.

I hope that helps.