Howdy folks! I am a bit stuck.
I created a pivot table but i am stuck..
I have a question regarding Gender And I have multiple questions which have multiple answers on a scale from 1 to 5. I would like to present them all in one pivot
Question a -> 1 - 2- 3- 4- 5
Question b -> 1 - 2- 3- 4- 5
Question c -> 1 - 2- 3- 4- 5
Question d -> 1 - 2- 3- 4- 5
Question f -> 1 - 2- 3- 4- 5
I need to sort the answers first of all by gender and then by the questions.
I can make pivot table for every question, but i was wondering can i do them all in one? (example attached)
My pivot looks that I have Gender in Column
Value in row, and question count in values
and i get the number of answers in total, but i am trying to break it down by the answer option to have something like this
Female Male
1 2. 3. 4. 5 1. 2. 3 4. 5
Question a -> total answers by option
Question b ->
Question c ->
Question d ->
Question f ->
So I need to add something under columns which will get me a scale from 1 to 5 in the columns and then sort the answers below.. (i am not sure was i clear enough) but please find the example attached
Hope someone can help out! Thanks in advance ..
Bookmarks