Trasform grouped header in a proper table  [Solved]

luca
Posts: 26
Joined: Sun Mar 03, 2019 6:08 am

Trasform grouped header in a proper table

Postby luca » Fri Jun 28, 2019 1:04 am

Hi all,

i would like to trasform the following table using power query.
the excel grouped header has to be the header of the new table while the year has to become a column
can anyone help me with this transformation.
Thanks
bye
Luca
Attachments
trasform in a table.xlsx
(15.18 KiB) Downloaded 32 times

Rudi
Posts: 16
Joined: Fri Sep 01, 2017 4:33 pm

Re: Trasform grouped header in a proper table  [Solved]

Postby Rudi » Fri Jun 28, 2019 5:51 pm

Attachments
trasform in a table.xlsx
(26.36 KiB) Downloaded 35 times

luca
Posts: 26
Joined: Sun Mar 03, 2019 6:08 am

Re: Trasform grouped header in a proper table

Postby luca » Wed Jul 10, 2019 2:23 am



Return to “Power Query”

Who is online

Users browsing this forum: No registered users and 0 guests