Forum Discussion
Using Power Query to Merge Excel Sheets Stored into a Folder
I have been successful in using Power Query to merge several excel sheets stored in a folder as one table. My concern is "what-if" a future excel file stored in the folder introduces new columns or ...
It's your choice. The Table.Combine function is smart enough to append tables even if they don't have the same columns, or have columns in different order, are missing columns, or have extra columns. The end result is a full combination of all found columns with matches where possible and null where not.