區域同名 彙整相聚 (10933)

B2=LEFT(A2,FIND("：",A2)-1)

C2=IF(B1<>B2,A2&IF(B2=B3,C3,""),SUBSTITUTE(A2,B2&"：",)&IF(B2<>B3,"",C3))

D2{=INDEX(C:C,SMALL(IF(B$1:B$9<>B$2:B$10,ROW($2:$10),99),ROW(A1)))&""