Power Query Multiple Headers

[chakravarthypsk]

Hi All,

I am working on the Power Query, I have multiple headers in my report, wherein I want only the date header to be unpivoted to fit my needs. However, I am not able to do it. Can someone help me in this regard.

Below is an example of the file .

I have the date in the same row where as i want it in the column.

SSSS

16-Sep-19

17-Sep-19

Performance

Performance

SL. No.

WIN ID

Name

Location

Team Leader

Team

Volume Processed

B Hours

T Hours

it

Achieved Time

Efficiency%

Utilization %

Actual TC Hours

Downtime

Utilization %

Volume Processed

B Hours

T Hours

it

Achieved Time

Efficiency%

Utilization %

Actual TC Hours

Downtime

Utilization %

Thanks,'
psk

 

[I_cant_read]

Maybe try the ff:

I assume the first two rows are irrelevant.

1.)Demote headers of that table
2.)Go to home > remove rows one and two
3.)Go to transform > use first row as header
4.) Finally highlight the columns you need to unpivot.

Table.DemoteHeaders - PowerQuery M

Learn more about: Table.DemoteHeaders

docs.microsoft.com

Just guessing if this is the answer your looking for.