Split & Group Text and Perform Distinct on Each Group
Problem description & analysis: Below is an irregularly categorized detail table. Column A and column B are categories and both have duplicate values. Column C contains detailed data consisting of strings separated by “comma+space”, and there are duplicates among the...
