3 Replies Latest reply on May 23, 2018 7:36 AM by Tim Dines

    Data reshape - group data columns as rows

    Bharat A

      My columns are exhaustive and I want to convert them to rows.

       

      My input and expected output is attached. Please help.

       

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          

      #PANPeriodA_cat1B_cat1C_cat1D_cat1E_cat1Total_cat1A_cat2B_cat2C_cat2D_cat2E_cat2Total_cat2A_cat3B_cat3C_cat3D_cat3E_cat3Total_cat3A_cat4B_cat4C_cat4D_cat4E_cat4Total_cat4
      1ABCD1234Sep100100100100100500100100100100100500100100100100100500100100100100100500
      2ABCD1234Sep858585858542533333155454545454270100100100100100500
      3ABCD1234Sep1001001001001005001001001001001005001001001001001005002222222222222221110
      4ABCD1235Sep100100501001004501001001001001005001005010050100400201001000100320
      5ABCD1235Sep10010001001001001400100100100100100501001001005010045020100100100100420
      6ABCD1236Sep100100100501004502222222222222221110100100100501004502066666666284
      7ABCD1237Sep1000100100030010001005010035010010010050100450100010001000100010005000
      8ABCD1237Sep10010010010010050010010010010010050010010010050100450201001000100320
      9ABCD1238Sep10010010050100450100501001001004501001001005010045020100100100100420
      10ABCD1239Sep100100100100040010010010010001000230010010001000501000315020100100100100420
      11ABCD1239Sep100100100100100500100010010003001000100500250201001000100320
      12ABCD1240Sep10010001000100010032003333333333333331665100100100501004502312312312312311155
      13ABCD1240Sep100100100100100500100100100100100500100100100100100500100100100100100500
      14ABCD1241Sep333333333333333166543434343432154324324324324322160100100100100100500
      15ABCD1242Sep1001001001001005001001001001001005001001001001001005008888888888888884440
      16ABCD1242Sep100100100100100500100100100100100500100100100100100500100100100100100500