Good afternoon: I am trying to concatenate characters from different rows as per example below: Starting table: Patient_ID Diagnoses 123456 463.0 123456 472.9 123456 V10.0 Finishing table: Patient ID Concatenation_Of_Diagnoses 123456 463.0; 472.9; V10.0 I have been splitting tables and using CATX, but if there are a lot of different diagnoses, writing the CATX function can take a long time and it doesn't seem to be an efficient process. Is there a better way to do that or a function in EG that allows to do that? Many thanks, Chantal
... View more