Forum Discussion
get data from 2 table with different column as one query
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 |
HI Anonymous
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/
1 Reply
- VahidDM
Super User
HI Anonymous
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/