I have a data sheet where are stored numerous matches that I played. Each match has a number of relevant columns such as Opponent and Result.
I have made a pivot sheet that counts for each opponent the number of wins across the data sheet.
The problem is that the table will record every misspell of the value for opponent separately.
Is there a way to agglomerate rows (and sum the counts) depending on how similar they are?