1 Reply Latest reply on Oct 10, 2018 7:58 AM by John Ajewol

    Rows of Data into Delimited List

    Dan Reber

      Hi,

       

      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 --

      PatientIDProviderID
      11
      12
      13
      23
      32
      33
      41

       

      I would like the output to look like --

       

      PatientIDProviderIDs
      11,2,3
      23
      32,3
      4

      1

       

      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.

       

      Thanks

       

      Dan Reber