get data from 2 table with different column as one query

[supasith]

dear friend

how can I get data from the table in excel files (there are different columns) and merge them as one query but keep all column from both

example

table1

Date	Column A	Column B
1
2
3

table2

Date	Column C	Column D
1
2
3

what I expect

Date	Column A	Column B	Column C	Column D
1
2
3

[VahidDM · Accepted solution]

HI @supasith 

You can merge those 2 tables in Power Query, see the below link:

https://docs.microsoft.com/en-us/power-query/merge-queries-overview

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/