Append one table to another and NOT create a new master table

[freelensia]

Hi,

I have table A like this
Name Age
John

 

[freelensia]

Then I have Table B in the same Excel file

Age Name
44 Peter

I want to append table B to the BOTTOM of table A.

So I go to Query Editor - Add Source - Choose this Excel file - Choose table A
Then I click the top-left window icon -- Append Query -- Choose this Excel file - Chose table B

At the end, Excel create a new table C with the values from both tables.

I don't want this. I just want to append table B to the BOTTOM of table A.

NOTE
I cannot just copy and paste manually because
- The real tables have 30+ columns
- The columns are in different order

I cannot re-order table B before pasting because:
- Table B comes from the Google Sheet data of a Google Form
- I need to do this import task every month, and it does not make sense to have to re-order 30+ columns each time

Thanks for your help!

Freelensia Interpreter Reservation Platform

 

[peter789]

Make sure both tables are loaded into the query editor. The second table can be set as connection only.
Open the first table then click the arrow to the right of append queries. Do not select Append as new, click append queries. Select the second query and the job is done.
Make sure the table column headers are exactly the same by the way.

Peter