Listing multiple diseases for a single patient

[MimiM]

Hi

I have an SQL extract table of patients with one or more diseases recorded for them. Each patient/disease information is a separate record/line. Through a pivot, I can see which patient has more than one disease recorded and which diseases are included. However, the pivot contains all possible diseases (columns) and all patients (rows).

My aim is to list each individual patient, with only the diseases recorded against them as columns. I would then try to summarise the combinations of diseases.

Any ideas, please?

Many thanks in advance

Mimi

Structure;
Patient 1 Disease A Practice X
Patient 1 Disease F Practice X
Patient 2 Disease B Practice Y
Patient 2 Disease G Practice Y
Patient 2 Disease H Practice Y
Patient 3 Disease A Practice Z
Patient 3 Disease C Practice Z

Aiming at

Patient 1 Practice X Disease A Disease F
Patient 2 Practice Y Disease B Disease G Disease H
Patient 3 Practice Z Disease A Disease C

etc.

 

[MimiM]

You are very welcome. It was an interesting exercise for me.
On the face of it, looks like hypertension could be a particular focus.

Was this using the approximately 16,000 records that you had mentioned earlier?

Yes, it was. I was surprised how quickly it came up with the results.

hypertension is a bit of a grey area. More kind of a condition than a disease but the jury is still out.
I’ll continue to keep an eye at the forum, some interesting cases there, though many of the solutions are way over my head