Merging Multiple Rows and Columns into a single Row

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

Hi Olly

I've added an example file in the format you've request (hopefully it makes sense)

There are quite a few rows but in my head, a solution for 1 row should be applicable to all rows as long as the merging review ID is the same

Let me know if anything else is needed

Thanks

Dan_B