Forum Discussion
How to Append Tables with Different Column Order with Automatic Refresh
There are 4 tables that I am wanting to append together, though their columns aren't in the same order (even some with more columns than other) that need to be in one table and have the ability to au...
Hi lankyman22
Tables all appended with the correct columns all lining up
No problem with Power Query/Get & Transform. Resulting table columns order depends on the order of the 1st table
Automatically refresh when new data is pasted into the data tables
The resulting query table can auto-refresh every 1 minute (and/or on workbook opening), not as you enter/paste new data - this would require VBA (not my expertise) to "detect" a change on any of your tables and to refresh the query on your behalf