Forum Discussion

Matty's avatar
Matty
Icon for Helper II rankHelper II
8 years ago
Solved

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

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 list...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago

    Hi Matty

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

     

     

    Best Regards

    Maggie

Seward12533's avatar
Seward12533
Icon for Solution Sage rankSolution Sage
8 years ago
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.