Forum Discussion
Table Merge from Web
When you first select the desired tables to be imported, click the drop-down arrow beside "Load" and select "Load To...", then select "Only Create Connection" and click "OK".
If you've already imported these tables into your workbook, go to Data > Queries and Connections, right-click on each table query, select "Load To..." and change it to "Only Create Connection".
After all of the desired tables have been imported as "Connection only", go to Data > Get Data > Launch Power Query Editor..., select the first table query in the left-hand pane, then go to Home > Append Queries > Append Queries as New and add the applicable tables to append.
From there you can modify the query as needed to clean the data, then "Close and Load" to a table in the workbook. Please see the attached sample file, if needed...
Use data in Excel → Get Data → Import the table from the Web, through the Power Query editor associated with multiple tables of data, and finally point to close and upload the integration can be completed!