I'm hoping someone can help me. Will do my best to explain.
I have a list prospects in column A which can appear more than once because they have have more than one person assigned in one of 3 roles. In column B, I have 3 different roles and in column C I have a person's name.
Example:
How can I transform this list so that the prospect is one 1 row and the column headers are as follows:
Thank you for anyone who can help
Sonya
I have a list prospects in column A which can appear more than once because they have have more than one person assigned in one of 3 roles. In column B, I have 3 different roles and in column C I have a person's name.
Example:
Prospect 1 | DO Contact | CA |
Prospect 1 | Primary | GU |
Prospect 1 | Co-Solicitor | DD |
Prospect 2 | Co-Solicitor | BV |
Prospect 2 | DO Contact | CA |
Prospect 2 | Primary | AV |
Prospect 3 | DO Contact | CA |
Prospect 3 | Co-Solicitor | GU |
Prospect 3 | Primary | DD |
How can I transform this list so that the prospect is one 1 row and the column headers are as follows:
DO Contact | Primary | Co-Solictor | |
Prospect 1 | CA | GU | DD |
Prospect 2 | CA | AV | BV |
Prospect 3 | CA | DD | GU |
Thank you for anyone who can help
Sonya