Hi! I'm trying to make pivot tablefor a survey.
The columns of my pivot table has 3 categories, defined by the answer of Q1.
Followed by mc questions of which a couple allow multiple answers. Each answer has an own column in my dataset, like so:
Q2.1, Q2.2, Q2.3, which for Q2.1 will either be "1" or "empty" and so on.
When I try to add all the columns for one question (Q2.1, Q2.2, Q2.3) in my pivot chart as rows, they become columns in the rows.
It's also one big mess because of the empty cells.
I basically just want the absolute numbers per answer (row), per category (column).
Thanks in advance!
Edit: I cannot attach a file, so here is an image to make things more clear.
voorbeeld.png
Bookmarks