Populating cell value with matching criteria into a result column

[aod2020]

I have occurrences of the same person but with a different value in a column(condition column in example below) and I'd like to show all the results for the individual people on one row with the different values in cells within the same row.

The first three columns is the data I have to work with and I want to show the conditions that the same person has across from their name in one row but in different columns.

Condition	Name	DOB	Diabetes	Asthma	IHD	A Fib	COPD
Diabetes	Joe Bloggs	01/01/1981	Diabetes
Asthma	Joe Bloggs	01/01/1981		Asthma
IHD	Joe Bloggs	01/01/1981			IHD
A Fib	Joe Bloggs	01/01/1981				A Fib
COPD	Joe Bloggs	01/01/1981					COPD
Diabetes	John Smith	19/12/1965	Diabetes
COPD	John Smith	19/12/1965					COPD
IHD	Mary James	11/07/1978			IHD
A Fib	Mary James	11/07/1978				A Fib
COPD	Mary James	11/07/1978					COPD
IHD	Polly Kettle	14/02/1976			IHD
Diabetes	Polly Kettle	14/02/1976	Diabetes
A Fib	Polly Kettle	14/02/1976				A Fib
Asthma	Laine Street	29/11/1970		Asthma
Diabetes	Laine Street	29/11/1970	Diabetes

[#2]

Hi @aod2020 

Assuming you run a recent version of Excel on Windows, with Get & Transform aka Power Query

Sample attached

[#3]

Thanks a million Liz, I was lost in never ending formula and data sorting. Your solution looks like just what I need. I will try that out.

[#4]

Welcome @aod2020. Just be aware this is a mock-up that will fail if you have duplicates, i.e. John Smith listed 2, 3... times with the same Conditions