Uploaded January 2024 | Updated November 2026, 5 hours ago
Ever had a gnarly PDF that you need to extract data and reshape? Today let me share an advanced Power Query trick with you. You can use this to reshape (split & combine) PDF tables. Later on in the video, I explain how to build a CUSTOM FUNCTION in Power Query so you can automate the task next time. Don't miss the ending!
๐Sample files:
Try it yourself on the PDF ๐
chandoo.org/wp/wp-content/uploads/2024/01/Pageexample2.pdf
Completed Excel File with PowerQuery transformations + custom function ๐
chandoo.org/wp/wp-content/uploads/2024/01/pdf-split-and-combine-demo.xlsx
โฑ IN THIS VIDEO:
0:00 - The PDF Table Problem
0:47 - Getting the data from PDF
1:40 - Power Query Parkour Time ๐ช๐โโ๏ธ
4:16 - Creating a PQ Custom Function to split and combine tables
7:00 - Invoking the function on your PDFs
8:42 - But there is more...
๐ฉโ๐ป MORE VIDEOS ON POWER QUERY
Learn Power Query in 15 minutes - youtu.be/UAFExySaSPY
Complete Master Class on Power Query (90 mins) - youtu.be/PiFAa_jjaEI
Combine PDFs with Power Query - youtu.be/5I0pnj_-LLA
Combine Sheets with Power Query - youtu.be/k_ugshJ4wIw
Combine Workbooks with Power Query - youtu.be/SGzegma9bdY
Multiple Find Replace with PQ - youtu.be/YWAMaas_1AU
Power Query - Automating 5 Data Tasks -
youtu.be/yJum0g4qM2c
Power Query Playlist - youtube.com/playlist?list=PLmejDGrsgFyBqyHBq4jqdUzobCo5BDKY2
Power Query Mini Course - chandoo.org/wp/power-query-power-course
~
Why did the PDF break up with his girlfriend?
Because she is not on the same page ๐
#powerquery
Ever had a gnarly PDF that you need to extract data and reshape? Today let me share an advanced Power Query trick with you. You can use this to reshape (split & combine) PDF tables. Later on in the video, I explain how to build a CUSTOM FUNCTION in Power Query so you can automate the task next time. Don't miss the ending!
๐Sample files:
Try it yourself on the PDF ๐
chandoo.org/wp/wp-content/uploads/2024/01/Pageexample2.pdf
Completed Excel File with PowerQuery transformations + custom function ๐
chandoo.org/wp/wp-content/uploads/2024/01/pdf-split-and-combine-demo.xlsx
โฑ IN THIS VIDEO:
0:00 - The PDF Table Problem
0:47 - Getting the data from PDF
1:40 - Power Query Parkour Time ๐ช๐โโ๏ธ
4:16 - Creating a PQ Custom Function to split and combine tables
7:00 - Invoking the function on your PDFs
8:42 - But there is more...
๐ฉโ๐ป MORE VIDEOS ON POWER QUERY
Learn Power Query in 15 minutes - youtu.be/UAFExySaSPY
Complete Master Class on Power Query (90 mins) - youtu.be/PiFAa_jjaEI
Combine PDFs with Power Query - youtu.be/5I0pnj_-LLA
Combine Sheets with Power Query - youtu.be/k_ugshJ4wIw
Combine Workbooks with Power Query - youtu.be/SGzegma9bdY
Multiple Find Replace with PQ - youtu.be/YWAMaas_1AU
Power Query - Automating 5 Data Tasks -
youtu.be/yJum0g4qM2c
Power Query Playlist - youtube.com/playlist?list=PLmejDGrsgFyBqyHBq4jqdUzobCo5BDKY2
Power Query Mini Course - chandoo.org/wp/power-query-power-course
~
Why did the PDF break up with his girlfriend?
Because she is not on the same page ๐
#powerquery










