Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

How to convert 2 tables into one where only column A can be the same as both

Copper Contributor

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

1 Reply

@Ana_Leal 

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.

combine two tables.png