Forum Discussion
Tallying categorical values in pivot table
I have a spreadsheet of data from survey results. There are 5 statements, and respondents respond with Strongly agree, Agree, Disagree, and strongly disagree for each: respondent statement 1 statem...
Holing,
your data is already in crosstabular form. What you need is a list of records:
Respondent - Statement ID - Statement text
There are many ways to unpivot and the best way is Power Query.
How do I unpivot?