Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Data shapping - Multiple parameters in both rows and columns

Hi all,

 

I am seeking your help to solve a problem of data shapping. I really think it is basic but I could not find a solution by myself or online (key words are not obvious).

 

My data is in an Excel file. This Excel file is a query from an Essbase database.
The key point is that I cannot change the structure of this file. 

 

Here is the retrieve from Essbase imported in Power BI (limited to a few columns and rows for the topic :) )

 

 

What I am trying to obtain is this :

A database with 1 data per row.

It is easy to achieve this with only 1 parameter in column (in the screenshot above, I removed my column "Diesel" and only kep the stations) : first I transpose the table and then I unpivot the columns.

 

But I don"t know how to do when starting with two parameters in column (the name of the station and the product, here Diesel)..

 

Any help would be really appreciated !!

Best regards,

 

Benjamin

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi all,

     

    I'm still looking for help regarding this topic. That would be great !  

     

    Best regards,

     

    Benjamin

    • Anonymous's avatar
      Anonymous
      Not applicable

      Up

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi,

     

    I am still looking for help regarding this problem. Any clues please ?

     

    BR

    • Anonymous's avatar
      Anonymous
      Not applicable

      Up !

  • Anonymous's avatar
    Anonymous
    Not applicable

    Any clues please ?