How to combine lists and remove duplicates in Power Query...

[Matty]

Hi,

I have two lists like as follows:

List1

Team1

Team2

Team3

Team4

List 2

Team1

Team2

Team5

Team4

I want to use Power Query to append the two lists and then remove the duplicates.  This would result in a list like this:

All

Team1

Team2

Team3

Team4

Team5

Can someone help me with the syntax needed to achieve this?  I'm running into problems because the fields are called different things, so Table.Combine isn't working as desired.

Thanks,

Matty

[v-juanli-msft · Accepted solution]

Hi @Matty

For the two lists, select "Append as new", then select "Remove rows"->"Remove duplicates".

Best Regards

Maggie

[Seward12533]

Assuming your doing this Power Query. Make a Refence copy of of one of your lists and rename the column headers so they are the same prior to the merge. You can stop the interim query from returning values by combining the queries manually in advanced editor or by right clicking the query and I checking the Load To portion.