Data shapping - Multiple parameters in both rows and columns

[Benjamin14]

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

[Benjamin14]

Any clues please ?

[Benjamin14]

Hi,

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

BR

[Benjamin14]

Up !

[Benjamin14]

Hi all,

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

Best regards,

Benjamin

[Benjamin14]

Up

[Benjamin14]

Up

[Benjamin14]

Up 🙂

[Benjamin14]

Up !