Forum Discussion

donodackal's avatar
donodackal
Helper I
4 years ago
Solved

How to remove/filter out rows on the condition that every column for both rows have matching data?

Hi there, I receive weekly reports from our travel providers that I consolidate using power query. I find that there are some rows between several weekly reports that duplicate the same information. ...
Need Help
  • Thingsclump's avatar
    Thingsclump
    4 years ago

    Hi donodackal 

     

    In powerquery editor, select columns A to G and remove duplicates. It will remove duplicates if values in all columns are repeated. 

     

    Thanks

Thingsclump's avatar
Thingsclump
Resolver V
4 years ago

Hi donodackal 

 

In powerquery editor, select columns A to G and remove duplicates. It will remove duplicates if values in all columns are repeated. 

 

Thanks