Get single value of duplicates|Power Query|Excel Forum|My Online Training Hub

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