Forum Discussion
Consolidating with Power Query: Extra/Missing column Error
Hello everyone, I am trying to consolidate data with Power Query. I use get Data --> From Folder. Each .XLS (97-2003 format) sheet that I am trying to consolidate have the same structure. So in ...
In general it shall work. If you create empty file with maximum number of possible columns and apply to it exactly the same headers transformations as for other files with data, Power Query shall combine everything correctly.