Convert this "hell" table with Power Query

rolo
Posts: 15
Joined: Tue Sep 27, 2016 8:14 am

Convert this "hell" table with Power Query

Postby rolo » Sat Feb 04, 2017 5:40 am

Hello, I would apprecciate your help to convert this table using Power Query.

See image and attached excel example below

Image

Thanks!
Attachments
LotOfHeadersTable.xlsx
(11.54 KiB) Downloaded 70 times

MattAllington
Posts: 929
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Convert this "hell" table with Power Query

Postby MattAllington » Sun Feb 05, 2017 7:59 am

One issue I see is that it is actually 2 tables, not 1. And I assume it can be 3 or more. Anyway I made a single table and came up with this process. You would need to validate if it works with 3 + tables
LotOfHeadersTable.xlsx
(23.46 KiB) Downloaded 78 times
Matt Allington is Self Service BI Consultant, Trainer and Author of the book "Supercharge Power BI".
https://exceleratorbi.com.au/power-bi-online-training/

rolo
Posts: 15
Joined: Tue Sep 27, 2016 8:14 am

Re: Convert this "hell" table with Power Query

Postby rolo » Sun Feb 05, 2017 11:07 pm

As you can see, it is only one "hell" table, but it has lot of headers and intermediate empty rows and columns

I will check your solution and will tell you something ASAP

Thanks!

rolo
Posts: 15
Joined: Tue Sep 27, 2016 8:14 am

Re: Convert this "hell" table with Power Query

Postby rolo » Wed Feb 08, 2017 12:33 am

Hi Matt, your Power Query solution worked like a charm! ;)

By the way, I have bought your ebook "Learn to Write DAX"...it is very nice and I am learning a lot

Thank you very much for your great help!

MattAllington
Posts: 929
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Convert this "hell" table with Power Query

Postby MattAllington » Wed Feb 08, 2017 7:49 am

Great, hope you enjoy the book. I am currently developing online Power Query training which I hope to release by the end of March if you are interested. Http://xbi.com.au/pqt
Matt Allington is Self Service BI Consultant, Trainer and Author of the book "Supercharge Power BI".
https://exceleratorbi.com.au/power-bi-online-training/


Return to “Power Query”

Who is online

Users browsing this forum: No registered users and 2 guests