Hi All
This feels like a very complicated question and I've searched the best way I know how to find an answer but not sure any of the solutions help with what I am trying to achieve
I have a large .CSV file (can be changed to .xlsx if needed) which has a list of reviews with multiple responses and each response is a new row but with the same review ID (See example below)
Review ID Question 1 Question 2 Question 3
1 5
1 4
1 3
Essentially, to be able to properly analyse this data I want to merge those rows with the same ID into 1 single row with all of the answers still under their respective columns
Is that possible and what is the best method of doing this?
Thanks for any help or guidance
Daniel
Bookmarks