Merge two rows of data
Hi I have a list of patient ID's, diagnosis and diagnosis date. I have it like this right now:IDLabelRow 1Row 2Row 3Row 4Row 5Row 6Row 7Row 81Diagnosisxxyyzzxx1Diagnosis date01/01/200001/01/200101/01/200201/01/200301/01/200401/01/200501/01/200601/01/20072Diagnosisxxyyzzxx2Diagnosis date01/01/200001/01/200101/01/200201/01/200301/01/200401/01/200501/01/200601/01/2007 I am trying to get it like this:...