Combine multiple sheets, columns and rows into a data list

[Anonymous]

Hello,

Im not sure this is doable in Power BI, however I give it a try. I have createad an cost report for our different locations (25-30 locations) and each location have their one cost report. What I have is column A-M, A = accounts and B-M = months. I need to get a big data list from this, what you can see to the right, column O-Q. With all accounts, all months and from multiple sheets (all our locations from multiple excel sheets).

Is it possible to create something like this in Power BI? In the end I will use the data list in a Power BI report showing cost, both per location and consolidated. 

Thanks!

[Anonymous]

@Anonymous 

Such requirements are just hard to understand clearly with description. It looks doable with some data shaping, like unpivot, relate tables, etc. It is not simple because the model needs to be rebuilded, try provide a short sample pbix includes the multiple excels, and also provide a expect output to that sample.

Regards
Paul

[amitchandak]

@Anonymous , Not very clear. You can Unpivot. But only for one level.

https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/