冒號後面不重複數據 提取 (15211)

C2:E7{=SUBSTITUTE(INDEX($A:$A,MIN(IF(ISNUMBER(SEARCH(C$1&":",$A$1:$A$13))*(COUNTIF(C$1:C1,MID($A$1:$A$13,LEN(C$1)+2,9))=0),ROW($1:$13),99)))&"",UPPER(C$1)&":",)