Forum Discussion

gianmarco's avatar
gianmarco
Icon for Helper IV rankHelper IV
5 years ago
Solved

Remove duplicates based on multiple conditions in Power Query

Dear All, I have the following table: ProdName CodeValue SourceCode Q.ty Apple NFOE 74891 3 Apple DNSA 74891 3 Kiwi FDAD 74891 4 Apple NFOE 55117 3 I want to rem...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    In the query editor, hold Ctrl and select the ProdName and SourceCode columns, then under Remove Rows pull down choose Remove Duplicates.

     

    Pat

     

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

In the query editor, hold Ctrl and select the ProdName and SourceCode columns, then under Remove Rows pull down choose Remove Duplicates.

 

Pat

 

  • gianmarco's avatar
    gianmarco
    Icon for Helper IV rankHelper IV
    5 years ago

    Simple as that... Kudos to you mahoneypat