6 Replies Latest reply: Jun 7, 2017 4:48 AM by Rohan Shetty RSS

    Is it possible to convert a crosstable into Straight Table

    Abhay Sudhakaran

      How the data looks like:

       

      CodeAttributeValue
      A001ColorBlue
      A001Grp220
      A001Grp3100
      A002Grp3200
      A002Grp210
      A002ColorRed
      A003Grp4120

       

       

      How I want it to look like:

      CodeColorGrp2Grp3Grp4
      A001Blue20100
      A002Red10200
      A003120