Hello,
I have received a spreadsheet with survey results and many of the questions have multiple answers in multiple columns. For example:
<tbody>
</tbody>
As you can see the formatting makes it a bit difficult to do quick pivot table etc analysis. Could you please provide any recommendations on how best/most efficiently to handle this? Should I just create a new column that combines the 4 columns of answers here so for example a@gmail.com's response would be HomeCar? Thank you.
I have received a spreadsheet with survey results and many of the questions have multiple answers in multiple columns. For example:
Respondent | Where do you keep the product? | |||
a@gmail.com | Home | Car | ||
b@gmail.com | Work | |||
c@gmail.com | Home | Car | ||
d@gmail.com | Rental Property |
<tbody>
</tbody>
As you can see the formatting makes it a bit difficult to do quick pivot table etc analysis. Could you please provide any recommendations on how best/most efficiently to handle this? Should I just create a new column that combines the 4 columns of answers here so for example a@gmail.com's response would be HomeCar? Thank you.
Last edited: