Forum Discussion

Matty's avatar
Matty
Helper 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

v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

Hi Matty

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

 

 

Best Regards

Maggie