combine two tables into one

[Anonymous]

Hi, 

I have two tables with same number or columns and same column names. (Using SQL to pull the data) I would like to combine them into one table. They both have unique identifiers and dont have any duplicates. 

table one has 300 rows 

table two has 200 rows

The combined table should have 500 rows

How do I do that? 

Thanks,

Daven

[AlB]

Hi @Anonymous 

NewTable = UNION (Table1, Table2)

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

[Anonymous · Accepted solution]

Hello @Daven - You can do this in Power Query

Transform Data > Select Table1, choose Append Queries (top banner)- Append queries as new - type Table2 as the second table, OK, and rename the new query to Table3.

Tabla1:

Table 2:

Table 3: (Add as new)

I hope this helps.

Bless you

-Namish B