7 Replies Latest reply: Jun 11, 2015 4:04 AM by Robert Ögren RSS

    Value of a cell in multiple rows transformed into same cell

    Paul McCormick

      HI,

       

      I have a table with multiple rows of similar data as below

      CustomerName

      Customer1

      Customer2

      Customer3

       

      I would like to have these all in the same cell like

       

      CustomerName

      Customer1, Customer2, Customer3

       

      Is there any build in function to do this?  The only thing I could think of is using multiple previous which could get quite wordy.

       

      CustomerName&’,’&previous(CustomerName)&’,’&previous(previous(CustomerName)) etc

       

      Thanks
      Paul