Joining complex tables
I'm trying to combine a couple of tables together and am having some problems. Basically my data sheets look like the following AgeSexPatient A13MPatient B15F DiagnosisPatient ADiabetesPatient AHTNPatient BAsthmaPatient BHTNPatient BSepsis I'm trying to make a table to combine the diagnoses with the patient codes (to look like the table below), but each patient diagnosis is represented individua...