In the previous post Rename column names in a dynamic way with #Excel #PowerQuery, I talked about the key steps involved to rename column names in a dynamic approach; and the inspiration as well as the thinking process.

As mentioned at the end of that post, we could apply the techniques for a practical and common problem – Append tables with inconsistent column names, as shown in the diagram above.

As promised, here’s the video to illustrate how to do it. I hope you like it. 😉

Thanks mma173 for the great tip of using List.Zip and MissField.Ignore

You may download sample files to follow along:

Data files:

Workbooks with the finished queries:

Note: Video in Cantonese is under production. Stay tuned now available. 😉