Power Query Tip for Dynamically Adding Missing Columns

Learn how to dynamically add missing columns back to your power queries.

Check out my full courses and ebooks here:

DOWNLOAD any example workbooks here:

SUBSCRIBE & get my 3 FREE eBooks.

CONNECT with me on social:

Thanks for all your support!

[HowToExcelBlog]

Check out my full courses and ebooks here

[wayneedmondson]

Hi John. Great tip! Very clever. Thanks for sharing it :)) Thumbs up!!

[mergeop]

This video was a life saver. Thanks ever so much!

[EricaDyson]

Great. Really really useful. This sort of disappearing act happens to me all the time. Now I know how to deal with it dynamically. Wonderful!

[johnabram]

Very nice. I've been looking for such a solution to handle structural changes to data from time to time. Thanks man!

[engahmedelbendary]

thx you so much, I like it and very useful to me

[ExcelOffTheGrid]

Nice solution. You also get bonus points for using the new Enter Data feature.

Good work John 😀

[kavita]

Nice video. I am having an issue with pdf documents, works fine for Jan but when I change source and replace it with Feb, one extra column is added which I don’t need but it breaks the auto refresh bcos of the extra column . Pls advise

[alejguz]

what if the columns must follow an order that affects the one that does not exits?

[MrSuperKotyara]

Hi! Can you please tell me, how can I get the same visibility of the Valid Errors and Empty cells at the top of a column?

[saheerali]

We can use the Unpivot option also as a solution, right?

[lne_wlf]

Hi, can you organise the excel tutorial in a playlist please, thank you.

[felipedeamorimcarvalho]

A question from Brasil!!! I Have a xls file and sometimes PowerQuery finds all the 6 Columns and sometimes it only finds 5 columns!!!!

It is the same file ( there are 6 Columns of data) !!!

I already have all the steps but I don't know how to solve this one error that appears randomly ....

Thanks for the video!!