Forum Discussion
Solved
Consolidating Rows
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.
Pivot the "Role" column with Values from the Person column and select "No Aggregation"
