I am looking to turn rows of data into a delimited list of values. For example, I have a list of patients and I want a single column of a comma delimited list of providers they have seen. The raw data has two columns - the PatientID and the ProviderID. The data will have a row for each ProviderID that a PatientID has.
Example data --
I would like the output to look like --
Any thoughts on how to do this in Prep? I have tried with Pivots and Aggregates but I can't seem to get it to work.