Jan 27 2022 02:04 PM
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 |
Jan 27 2022 10:19 PM
Hi @aod2020
Assuming you run a recent version of Excel on Windows, with Get & Transform aka Power Query
Sample attached
Jan 27 2022 11:59 PM
Jan 28 2022 02:54 AM