18 Replies Latest reply: Dec 11, 2017 3:02 PM by Andy Weir RSS

    Transpose columns in the display

    ra ta

      Hi,

       

      In the database, I have a large table that i load in the load editor part of which looks like this:

       

      CountryYearSales
      Japan201010
      Japan201111
      Japan201212
      Japan201313
      Japan201414
      Germany2010100
      Germany2011110
      Germany2012120
      Germany2013130
      Germany2014140
      UK20101000
      UK20111100
      UK20121200
      UK20131300
      UK20141400

       

      I am trying to use the data above to display the following table:

       

      CountryTotal SalesYear 2010Year 2011Year 2012Year 2013Year 2014
      Japan601011121314
      Germany600100110120130140
      UK600010001100120013001400

       

      Could you please suggest a solution to this. Thanks for the help.

       

      Regards,

      Ra