Forum Discussion
Different columns order
As you said, those different queries have same columns. You only need to care abouth underlying data instead of the rendering part in pivot table during data retrieval. If the underlying data included in those files is under same structure, you should be able to combine them into a single query via Power Query. Please refer to blog below:
Combine Multiple Excel Workbooks in Power Query
Regards,
As you said, those different queries have same columns. You only need to care abouth underlying data instead of the rendering part in pivot table during data retrieval. If the underlying data included in those files is under same structure, you should be able to combine them into a single query via Power Query. Please refer to blog below:
Combine Multiple Excel Workbooks in Power Query
Regards,
Now after I re-read the article more thoroughly, it seems the solution might prove useful, let me try this.