Intermediate-Advanced - Data Cleaning Techniques With Power Query - Nested Tables & Pdf files

During this session I show you how to clean and transform pdf files, working with nested tables in Power Query.

Files available here (right click & select download):

#SaturdayWithPowerQuery #PowerQuery #MSExcel #PowerQueryGirl

[SamehRSameh]

Great 👍, you are the best in M-code 🎉🎉
Plz need more and more ❤

[tonydreisenstock]

I have been absorbing your videos for over a year now. As I have become more proficient, my appreciation for your work has increased exponentially. This video is absolutely brilliant and your elegant sophisticated and effective use of nested queries and Table. TransformColumns is masterful - much neater then a many Table.AddColumns to achieve the same result.

My only gripe: whilst I fully understand that you are being polite, courteous and friendly when you greet your patrons as they enter your forum, I selfishly find this extremely irritating as I am impatient to absorb your latest gold nuggets of information. Notwithstanding, you have taught me so much and I cannot wait for your next instalment.

[roywilson]

Thank you for taking the time and effort to upload such an interesting and helpful video. I found you explanations to be concise and informative without being being patronising. You have definitely earned a subscription from me.

[zahoorsarbandi]

believe me such advanced concepts can only be expected from you Alejandra! A wonderful video with a lot of new concepts and information. I very much appreciate. 😄

[gospelmoto]

You must be a great guru! You've got a new subs here. Thanks for sharing your knowledge. Great help indeed!

[Kuldeep]

A wonderful workshop. I am learning and enjoying your workshops a lot. Great job. Pleae keep it up. Regards.

[Ratnakumarwrites]

Thanks for sharing this knowledge, watching all your videos helping a lot.

[mphandejohn]

a very powerful, and insightful video❤❤❤

[mhaince]

Hi there! great video and very clear instructions! i'm just wondering if you can also show us how to use pdf.multipagetables? i have a pdf that has a table that overflow to the next page. it doesn't have a header at all. Can i use PQ to transform it? Thanks a lot!

[antonysovy]

this is even better than previous video

[Lyriks_]

Why is this woman not mvp yet ? Microsoft ?