2 Replies Latest reply: Dec 20, 2016 8:05 AM by Sunny Talwar RSS

    how to convert to cross table  ?

    gaurav gopale

      Hi

      I have the following table

       

      i want to convert the "Original" table to "Output" table in the script .

       

       

      Original Table

      IDCategorySubCategorytype
      1Aa1,a2,a3Z
      2Bb1,b2,b3N
      3Cc1,c2Q
      4Aa1,a2X

       

       

      Output Table

      IDABCtype
      1a1,a2,a3Z
      2b1,b2,b3N
      3c1,c2Q
      4a1,a2X

       

       

      can anyone help me

       

       

      Thanks in Advance