Скачать или смотреть Append Tables with Inconsistent Column Names with

If you know Power Query, you should know that it's super easy to combine files in a folder, as long as all the tables across different files share common table structures, and column names.

When we have inconsistent column names across files, e.g. in some files we have "Dept", but "Department" in some other files, it is not that easy at all to combine them.

In this video, I am going to show you a way to do so, without advanced M-code. Well, a few lines of simple M-Code is still required though. 😁

And special thanks to mma173 for the tips of using List.Zip. It helps me take the solution to the next level. Don't miss the bonus section @12:33

I hope you like this video. If you do, please give a thumb up, share and subscribe my channel.

Blogpost, where you may download sample files to follow along:
https://wmfexcel.com/2021/04/25/appen...

#Excel
#PowerQuery
#Table.ColumnNames
#Table.RenameColumns
#List.Zip
#CombineFiles