Forum Discussion
Pivot tables: columns without nesting?
Hi, I have a dataset with a set of multiple variables that all have the same structure. They are questions with yes/no answers, and I want to know the % of cases that answered yes. I would like to s...
As expected your table is in a crosstabular format which already is a pivot table format.
You have to unpivot your data first and then create the pivot table.
As you also want to count the blanks you have to change them to a dummy value. Otherwise they get removed by the unpivot process.
Edit: I was to slow.