Read grouped columns of excel

[Mai_Nashaat]

hi guys,

I've an excel file with grouped columns as below:

I need to import it in power bi as below:

any help will be much appreciated please.

[danextian · Accepted solution]

Hi @Mai_Nashaat ,

Power BI will read the worksheet as is and will not matter whether rows or columns  have been grouped. If you want to achieve a result similar to below, Power  BI needs to be able to identify which rows are  the main and subtotals. You can either do this via a conditional column or doing a merge with a table with data that indicates kind of total a row is.

After that, extra columns are created in PQ and total rows are removed. 

Attached is a sample pbix to help you get started.

[Shaurya]

Hi @Mai_Nashaat,

You can do this by selecting these fields and using Unpivot Selected Columns.

Did I answer your question? Mark this post as a solution if I did!
Consider taking a look at my blog: Forecast Period - Previous Forecasts