Power Query

[Anonymous]

Hi,

I want to transpose the below table as month as one column,column  attribute  as " target and "actual" and its value in another column , struggling in transposing it. can you help me with this?

Thanks in Advance.

[Ashish_Mathur]

Hi,

See if my solution here helps - Rearrange a multi heading dataset into a single heading one which is Pivot ready.

[ryan_mayu]

@Anonymous 

1. use header as first row

2. transpose

2. use first row as header

4. exact column 1 to delete numbers