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 have attached a brief copy of what I am trying to achieve and to see if you can understand. View attachment forum upload.xlsx
I would be very grateful if anyone could help me
Megan:wacko:
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 have attached a brief copy of what I am trying to achieve and to see if you can understand. View attachment forum upload.xlsx
I would be very grateful if anyone could help me
Megan:wacko:
