B
Ben123
Hi,
I'm completely new to pivot tables and I don't know how best to structure
the source/raw data i have in order to create the pivot table(s).
I've got results from a multiple choice questionnaire I'm trying to analyse
with pivot tables. For some of the questions you can select (tick) more than
more answer, however, I don't know how to structure this raw data. Here are
several made up examples of several questions a person called Bob Smith could
have had to answer
From the following list select what flavour(s) ice cream you like?
From the following list select what car manufacturer you would consider
buying from?
Say bob answered with strawberry and vanilla for question 1 and ford and
toyota for question 2.
How would I structure this in excel? Would it be one row?!?
I'm completely new to pivot tables and I don't know how best to structure
the source/raw data i have in order to create the pivot table(s).
I've got results from a multiple choice questionnaire I'm trying to analyse
with pivot tables. For some of the questions you can select (tick) more than
more answer, however, I don't know how to structure this raw data. Here are
several made up examples of several questions a person called Bob Smith could
have had to answer
From the following list select what flavour(s) ice cream you like?
From the following list select what car manufacturer you would consider
buying from?
Say bob answered with strawberry and vanilla for question 1 and ford and
toyota for question 2.
How would I structure this in excel? Would it be one row?!?