table with header in multiple rows

[Anonymous]

Hi Everyone,

I have a table with multiple rows as header and repeated measures across columns, i tried with pivoting but not getting the desired output. any suggestions on how this can be transformed are really appreciated.

Zone

global

NAZ

Feb 2020 YTD

Feb 2020 MTD

Notes

Feb 2020 YTD

Feb 2020 MTD

Planned source

Initiative

KPI

Update Frequency

Comments

Data Source

Source

Status

Actual LY

Actual CY

2020 BU

Organic vs. LY ($)

Organic vs. BU ($)

Organic vs. LY (%)

Organic vs. BU (%)

Actual LY

Actual CY

2020 BU

Organic vs. LY ($)

Organic vs. BU ($)

Organic vs. LY (%)

Organic vs. BU (%)

Actual LY

Actual CY

2020 BU

Organic Growth vs. LY ($)

Organic var vs. Budget ($)

Actual LY

Actual CY

2020 BU

Organic vs. LY ($)

Organic vs. BU ($)

Thanks,

Shravan

[v-alq-msft]

Hi, @Anonymous 

I'd like to suggest you refer the following similar thread to see if it helps.

Convert excel matrix table to flattened table 

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[camargos88]

Hi @Anonymous ,

I can't copy the data like this. Can you fix it or share a pbix with some example ?

[Anonymous]

Hi

@camargos88 , please find the raw data and required output.

https://drive.google.com/open?id=1vX7BUyvK0N9CeUVKmmN6z8_KxQmpwoJB 

Thanks,

Shravan