1 2 Previous Next 18 Replies Latest reply on Sep 11, 2015 9:39 AM by Dennis Akande

    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