Power Query: Unstack data

Mathexcel

New Member
Joined
Jun 22, 2017
Messages
24
Hi Mr Excel Community,

I would like to unstack this data using Power Query in order to have a clean list to pivot.

Desired situation > To have a table with the following headers: Market, Items, Years, Month, Values.
Change vs prior Year will be filtered out of the data sample.

I know that I need to merge, transpose, unpivot, unmerge and pivot but does anyone have an idea how to split the Items colums into Years & Items?

Data Sample:


MarketItemsColumn2Column3
EnglandOccupancy (%)JanFeb
England20166070
England20176070
England20186171
England20196573
EnglandChange vs prior year (%)0.3943307430.063125438
EnglandAverage Daily RateJanFeb
England20167090
England20178086
England20188386
England20199087
EnglandChange vs prior year (%)1.690275579-0.105899308
EnglandRevPARJanFeb
England20165060
England20175662
England20185661
England20195553
EnglandChange vs prior year (%)2.091271599-0.04284072

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

Many thanks in advance for your precious time!

Best ,
Matt
 

Forum statistics

Threads
1,078,216
Messages
5,338,907
Members
399,267
Latest member
Danielle1017

Some videos you may like

This Week's Hot Topics

Top