Hi Everyone,
I am looking for some help turning data from a survey into a count table.
The original survey question looked something like this:
Screen Shot 2017-06-06 at 5.22.05 PM.png
Where the responders click one choice for each item.
The excel sheet that was generated looks something like this:
Screen Shot 2017-06-06 at 5.13.22 PM.png
With the responses coded as numbers.
How would I go about turning this into a data table that looks like this:
Screen Shot 2017-06-06 at 5.18.45 PM.png
With a count of the responses for each item?
I am not very experienced with Excel so I would really appreciate it if someone could tell me step-by-step.
Thank you!![]()
Bookmarks