Converting multpile rows per patient to one row per patient

[Leeanne2]

Hi,
I have a table of patients and their diagnoses where eachline contains a separate diagnosis and there can be many lines per patient.
I need to convert this to one row per patient with all ofthe diagnoses ordered Primary 1 diagnosis code, Primary 1 DiagnosisDescription, Secondary 1 diagnosis code, Secondary 1 diagnosis description,Secondary 2 diagnosis code, Secondary 2 diagnosis description, and so on till Irun out of codes and descriptions – sometimes this is lots.

I have an example of how I have done small datasets using vlookups but thisdoesn’t easily translate to massive datasets. I’m keen for advice on a better way to achieve this.

 

[alansidman]

Your image did not post correctly.

 

[Leeanne2]

Sorry about the picture - I don't know why it didn't post correctly and a don't have the permissions required to go back and edit the post to remove the image. hopefully someone who can will delete it for me!