Forum Discussion

Jeffrey T's avatar
Jeffrey T
Copper Contributor
Dec 15, 2022

Find and replace comma separated values

Hello Everyone,   I was provided an Excel sheet that has users in one column and the companies they belong to in another column, some with more than one group.   username company john.smit...
excel
Lorenzo's avatar
Lorenzo
Silver Contributor
Dec 15, 2022

Hi Jeffrey T 

 

A possible approach with Power Query function https://learn.microsoft.com/en-us/powerquery-m/table-fuzzynestedjoin and options:
    IgnoreCase=true, IgnoreSpace=true, Threshold=0.5

If more than 1 match the query keeps the one with highest similarity

 

Resources