3 Replies Latest reply: Jul 21, 2013 7:45 AM by Nuno Faustino RSS

    Multiple ID Column to one ID Row

    Nuno Faustino

      Hi guys,

       

      I want to transform table nr1 into table nr2 throught scripting.

       

      This example is with 3 columns but they should be as many as the maximum cases for one ID.

       

      Table nr1

      IDQ1
      1Red
      1Green
      2Blue
      3Blue
      3Green
      4Green
      4Red
      5Red
      5Green
      5Blue

       

      Table nr2

      IDQ1.1Q1.2Q1.3
      1RedGreen
      2Blue

      3BlueGreen
      4GreenRed
      5RedGreenBlue

       

      Thank you in advance for the help.

       

      Kind regards,

      Nuno