Transform Column to Columns to Remove Duplicate Unique_IDs in the Reporting

[seanrm42]

I need to tranform my data into a better structure for reporting but am unable to figure out so am reaching out for help.

I have the following data structure:

ID        Person_Role           Person_Name

1         Used By                  User_1

1         Managed By           Manager_1

1         Supported By         Supporter_1

2         Used By                  User_2

2         Supported By         Supporter_2

3         Used By                  User_3

3         Managed By           Manager_2

3         Supported By         Supporter_3

4         Managed By           Manager_3

4         Supported By         Supporter_4

5         Used By                  User_4

5         Managed By           Manager_4

6         Supported By         Supporter_5

I need to transform it to the following format:

ID        Used By         Supported By         Managed By

1         User_1            Supporter_1           Manager_1

2         User_2            Supporter_2           

3         User_3            Supporter_3           Manager_2

4                                Supporter_4           Manager_3

5         User_4                                           Manager_4

6                                Supporter_5

All help is greatly appreciated.

[v-yulgu-msft]

Hi @seanrm42,

Have you achieved your requirement? If yes, would you please mark the corresponding reply as an answer or share your solution so that it can benefit more users?

Regards,
Yuliana Gu

[seanrm42]

The post already has "Solved" on it and a link to click to the solution. Am I missing something?

[MarcelBeug]

Yes. Summer has gone and it's almost winter now. At least on the Northern Hemisphere.

[anktaggrwl · Accepted solution]

 Starting Table

Highlight "Person Role" column and choose 'Pivot Column' option - Choose 'Person Name' as values option, and in Advanced Options - Don't Aggregate

Result