Forum Discussion
How to remove duplicates from 2 columns using Power Query
How do I remove duplicates from 2 separe columns named (Account No) and (CRM). The requirement goes like this, I want to maintain only 1 single row when both columns have duplicates. and I do not...
Your example should work using the Remove Duplicates method.
Is there some reason you are unable to supply an example of data which does not work? I'm afraid without that, we would just be guessing as to your problem.
It would be most helpful if you provide usable data (as text which can be copy/pasted, not a screenshot) which reproduces your problem.