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 ...
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.