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 dup...