Merge rows based on a repeated value from a different column

I am trying to merge values from different columns form different rows based on an specific value in a different columns.

Based on the picture, what I want to do is combine the data into one row, with the third column as the value to look for and then combine all the data in one row

This could be a solution

1 Like