Can you combine 2 tables into one

[BobUmlas]

If I have table1 like this:
emp store
1 a
2 b
3 c

and table2 like this:
emp2 store
4 d
5 e
6 f

Can I get this using power pivot or power query or some BI tool (I know I can manually copy/paste & create a new table, but that's not my question):
Empl Store
1 a
2 b
3 c
4 d
5 e
6 f

Thanks
Bob Umlas
Excel MVP

 

[Matt Allington]

Yes, you should use power query. Connect each data source to power query, then save each as "create connection only". Before saving, make sure both queries have the same column names. Then you can create an append query where you append one to the other. Save this third query and import it to where every you need it.