1 2 Previous Next 19 Replies Latest reply on Aug 28, 2017 9:01 AM by abdul kareem

    Combining multiple rows into one

    Mikhail Venkov

      Hello,

       

      I am trying to combine multiple rows into one, grouped by another column. Here is an example:

      My data is this:

      CityName
      TorontoJeff
      TorontoJack
      TorontoJill
      MontrealAdam
      MontrealAdrian
      MontrealAllan

       

      And I want this:

      CityNames
      TorontoJeff, Jack, Jill
      MontrealAdam, Adrian, Allan

       

      Can anyone help me with this? My data source is sql server so I could write some sql code or use one of the pass through functions.

       

      Any help would be greatly appreciated!

       

      Thanks in advance!

        1 2 Previous Next