Pivot table

[Sonymacd]

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:

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

 

[Muhammad_Usman]

1235.xlsm
	A	B	C	D	E	F	G	H
1	Head	Job	Name			DO Contact	Primary	Co-Solicitor
2	Prospect 1	DO Contact	CA		Prospect 1	CA	GU	DD
3	Prospect 1	Primary	GU		Prospect 2	CA	AV	BV
4	Prospect 1	Co-Solicitor	DD		Prospect 3	CA	DD	GU
5	Prospect 2	Co-Solicitor	BV
6	Prospect 2	DO Contact	CA
7	Prospect 2	Primary	AV
8	Prospect 3	DO Contact	CA
9	Prospect 3	Co-Solicitor	GU
10	Prospect 3	Primary	DD
Menu

Cell Formulas
Range	Formula
F1:H1	F1	=TRANSPOSE(UNIQUE(B2:B9))
E2:E4	E2	=UNIQUE(A2:A10)
F2:H4	F2	=FILTER($C$2:$C$10,$B$2:$B$10=F1)
Dynamic array formulas.

 

[Muhammad_Usman]

@Sonymacd

Mark you post as solved . if your query sort out.