I have a spreadsheet created from a poll with 3 columns: unique id, question, answer (a numeric value)
Data repeats several times for each user like this:
User ID | Questions text | Answers |
---|---|---|
ID1 | question 1 | AnswerID1 |
ID1 | question 2 | AnswerID1 |
ID1 | question 3 | AnswerID1 |
ID2 | question 1 | AnswerID2 |
ID2 | question 2 | AnswerID2 |
ID2 | question 3 | AnswerID2 |
Ideally I'd like to group all question 1, with all different answers on the same row or column, so it's easier to make a graph to show results. Like this:
Question 1 | Question 2 | Question 3 |
---|---|---|
AnwerID1 | AnwerID1 | AnwerID1 |
AnwerID2 | AnwerID2 | AnwerID2 |
Any suggestion how it's the most efficient way to do this?