5 Replies Latest reply: Nov 5, 2015 8:11 AM by Mark Little RSS

    Concat multiple text rows

    Michael Kühn

      Hi,

       

      I have a table of the structure

       

      NumberRowText
      11Text1
      21Text1
      22Text2

       

      an I would like to transform it into a table of the structure

       

       

      NumberText
      1Text1
      2

      Text1 Text2

       

      So I would like to concatenate each row of text with the same dataset number (first column) in just one row.

       

      Thanks for any suggestion

       

      Michael