I have a column of text values with different writings and want to consolidate the different values into the most frequent ones.
Example:
The 1st and 3rd should become the same as the 2nd block. So, first need a rank of the values, and than a matching of lower ranked values to maybe higher ranked one.