14 Replies Latest reply: Apr 11, 2018 3:27 AM by Poojashri Bangera RSS

    Transpose Table

    ra ta

      Hi, I am displaying a table looking like the following:

       

       

      MaturitySales product1Sales product2Sales product3
      1 year5,9138,133-2,223
      2 year39,52538,560929
      3 year41,09439,8721,188
      4 year97,90479,5164,737
      5 year309,085290,6129,810
      6 year85,371109,4812,710

       

       

      That I would like to transpose to look like this:

       

          

      Maturity1 year2 year3 year4 year5 year6 year
      Sales product15,91339,52541,09497,904309,08585,371
      Sales product28,13338,56039,87279,516290,612109,481
      Sales product3-2,2239291,1884,7379,8102,710

       

       

      Any suggestions to do this please. Thanks very much.