Forum Discussion
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...
In the query editor, hold Ctrl and select the ProdName and SourceCode columns, then under Remove Rows pull down choose Remove Duplicates.
Pat
In the query editor, hold Ctrl and select the ProdName and SourceCode columns, then under Remove Rows pull down choose Remove Duplicates.
Pat
Simple as that... Kudos to you mahoneypat