Hi,
I have the results of a SurveyMonkey survey that contains a few different kinds of Likert scale questions. What I am trying to do is transform/pivot the data so that the Likert scale becomes the columns, the selections are counted and grouped by value and the question becomes the row. E.g.
| There is sufficient access to computers |
| Agree |
| Strongly disagree |
| Strongly agree |
| Agree |
| Neither agree nor disagree |
| Strongly agree |
| Neither agree nor disagree |
| Strongly agree |
| Disagree |
| ... |
Becomes:
| Question | Strongly Disagree | Disagree | Neither agree nor disagree | Agree | Strongly Agree |
| There is sufficient access to computers | 10 | 35 | 12 | 92 | 15 |
I feel this shouldn't be that hard, but I'm not having a great deal of success. I've tried many variations of summarizing, transposing, and cross-tabbing but can't seem to get what I want. Any help would be greatly appreciated!
