Consolidating Rows

[bbbarb]

Hi,

I am trying to consolidate/merge multiple rows into one. In the image you can see the ID column is what is shared in common with the Role and Person. Thanks.

[ronrsnfld · Accepted solution]

Pivot the "Role" column with Values from the Person column and select "No Aggregation"

[bbbarb]

Thank you!