Forum Discussion
How to convert 2 tables into one where only column A can be the same as both
Hello.
I want to mix 2 different tables with data from my company
In both tables I have:
Colum A - Supplier number
Colum B - Supplier Name
Then Table 1 - All my suppliers are there with registration information (address, phone number and so on)
Table 2 - yearly expenses - have number of invoices, total amount of invoices, and so on.
Note that In this second table some suppliers are not there because there's no invoice flow this year. So I need a simple way to match both tables without losing information from one or another
Question: How to create a single table that join
Colum A and B from both and a few more colums that I want to include from each table.
Thank you
Power Query returns the intended result in my understanding. In the attached file you can add data to the blue dynamic tables. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.
The data layout in the screenshot and in the attached file is for illustration. You can place the green result table to the right of the blue tables or in another worksheet.
