Forum Discussion
Cross-tabulations by using pivot table - multiple values
Hi all,
I've set up a questionairre for my master thesis whereby respondents 16 times had to choose which type of transport (bus, train or plane) they should use. Now I have, next to the socio-demographic data sixteen columns (because of the 16 different questions) of data with the answers of the respondents.
I would like to do cross tabulations, for example a table with on the vertical axis 1) male and 2) female and on the horizontal axis the options 1) bus, 2) train and 3) plane. This would result in a overview which displays how many times male or female chooses for bus/train/plane.
Everything what I try ends up in a mess.
Can someone help me out? Thanks a lot in advance!
- Detlef_LewinSilver Contributor
Jochem,
you have to unpivot the sixteen columns. Best way to to this is Power Query,
After that you have pivotable table.