Forum Discussion
Jochem Pon
May 30, 2018Copper Contributor
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-dem...
Detlef_Lewin
May 30, 2018Silver Contributor
Jochem,
you have to unpivot the sixteen columns. Best way to to this is Power Query,
After that you have pivotable table.