Forum Discussion

Tuna123's avatar
Tuna123
Frequent Visitor
8 years ago
Solved

Table transpose problem

  I'm working with a table that has profit centers as columns and P&L accounts as rows. Here's a simplified sample data:     I'm trying to transpose this table and unpivot the columns so th...
  • MFelix's avatar
    8 years ago

    Hi Tuna123,

     

    In the query editor select all the Profit center column and choose unpivot this will give you expected result.

     

     

    Regards,

    MFelix