Crosstab for multiple columns

[nataliad18]

Hi!

I have a rather complex dataset as it has *A LOT* of information (see attached file tab "input" as sample). 

I want to crosstab several key information to have desired output (see attached file tab "output" as sample).

N.B the file I attached is dummy data so Input tab is a small sample of the full tab and output file does not reflect correct "agree", "disagree" etc values from the input tab

I can only do crosstab for one, is there a way to do it in order to get a desired output in minimum amount of tools without having to use 100 summarize tools instead?

Thank you so much,

Natalia :) 

[PhilipMannering · Accepted solution]

Hi Natalia,

Are the numbers the count of respondents. Maybe this works?

[nataliad18]

This worked perfect! Thank you, Philip - massive help, as always 😁