Forum Discussion
Load in Excel Files with Changing Column Position and Names in Power Query Editor
I have an Excel file that looks similar to this table. Though sometimes, the 4th and 5th columns get switched (including their values) and are renamed a little differently within Excel to look...
By using Append Queries, you don't have to do any manual reordering
and the appended results will automatically append the correct columns.
= Table.Combine({#"Table1 (Col Order 1,2)", #"Table2 (Col Order 2,1)"})
Here we have three queries:
- Table1 (Col Order 1,2)
- Table2 (Col Order 2,1)
- Append Table1 + Table2 (Col Order 1,2)
https://learn.microsoft.com/en-us/power-query/append-queries