Hi team, I'm looking to combine rows based on whether or not a text variable (always just a single word) appears within another text variable. E.G. I want to treat "apple" and "apples" as the same word and take the sum of the quant data for each. The resulting word that is displayed will always be the largest of the words that were combined. Word quantity apples 2 apple 3 orange 5 banana 3 to this: Word quantity apples 5 orange 5 banana 3   Note that I'm not looking to combine misspelled words, only words that contain other words. Thanks! ... View more