Hello!

I have a data set of survey questions which looks something like this. Each row is one person.
before.png


Answers are 1, 2, 3 or 4.

I would like to make a pivot tabel which summarize each departments

After.png


How is that possible? Havent found instructions on internet.

Thanks!