Learn Excel - Combine 4 Sheets - Podcast 2178

Doug: How to combine four sheets where each has a different number of rows?
Use Power Query
Format each worksheet as a Table with Ctrl+T
Rename the tables
For each table, new query From Table. Add a custom column for Region
Instead of Close & Load, choose Close & Load to… Only Create a Connection
Use New Query, Combine Query, Append. 3 or More Tables. Choose the Tables and Add
Close and Load and the data appears on a new worksheet
For the one table with extra column: the data shows up for only that sheet's records
For the one table where the columns were in the wrong order: Power Query worked correctly!
Easy to Refresh later

Видео Learn Excel - Combine 4 Sheets - Podcast 2178 канала MrExcel.com