Transform Column to Columns to Remove Duplicate Unique_IDs in the Reporting

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.