Forum Discussion

donodackal's avatar
donodackal
Icon for Helper I rankHelper 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

v-jingzhang's avatar
v-jingzhang
Icon for Community Support rankCommunity Support
4 years ago

Hi donodackal 

 

Thingsclump 's solution should work, have you tried that?

 

Below are detailed steps:

1. Hold press on Shift or Ctrl key and click on column headers to select all columns.

2. Go to Home > Remove Rows > Remove Duplicates.

 

You can also enter = Table.Distinct(#"Previous step name") in the formula bar to add a step to remove duplicated rows in the whole table. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.