Forum Discussion

Jochem Pon's avatar
Jochem Pon
Copper Contributor
May 30, 2018

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_Lewin's avatar
    Detlef_Lewin
    Silver Contributor

    Jochem,

     

    you have to unpivot the sixteen columns. Best way to to this is Power Query,

    After that you have pivotable table.

     

Resources