Retain only unique duplicate combination

[udaycontact]

Hi,

I have a database of vendor master.. I am using fuzzy logic to get the duplicate vendors based on vendor names..

The output that i have is like below :

Vendor Name | Duplicate Vendor Name

A | AA

AA | A

Since i am doing fuzzy logic in the same table (Based on vendor name column), i would get 2 rows as above.

I want to keep only only combination of duplicate ie. either A | AA or AA | A, as both would mean the same thing in this context.

I tried various ways of trying to map this combination as a unique value and trying to remove duplicate, but i couldn't assign a unique value.

Any help is much appreciated !

Kind Regards

 

[AlanSidman]

crosspost: https://www.myonlinetraininghub.com/excel-forum/power-query/get-single-value-of-duplicates

Please read: https://www.excelguru.ca/content.php?184

 

[vletm]

udaycontact
You should reread Forum Rules

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

There are clear sentences for those who uses Cross-Posting.
Those rules are for Your too.
Ps. Same kind of rules are everywhere.

 

[udaycontact]

Noted. Thanks !