add multiple same structure tables into one

[troyrowlands]

I have data from two sharepoint lists. The one list went over 5000 items and we had to create a new list for new data. The lists are identicle in structure, but have different data in them. How do I simply join the old and new records in to a new table.

e.g

Table: 1      Table 2

ID Data       ID Data

1 xyz           1 fre

2 xse           2 bbg

3 dft            3 frt

Required

Table 3

ID Data

1 xyz           

2 xse           

3 dft           

1 fre

2 bbg

3 frt

Many thanks

Troy

[MarcelBeug · Accepted solution]

In "Edit Queries", select Table1, choose Append Queries - Append Queries as New - enter Table2 as the second table, OK and rename the new query to Tabe3.

Code generated:

let
    Source = Table.Combine({Table1, Table2})
in
    Source

Alternatively, you can create a new blank query, enter in the formula bar: = Table1 & Table2, rename the new query to Table3.