整理原始数据 (10679)

B2 下拉{=INDEX(A:A,SMALL(IF(ISERR(FIND(":",A$2:A$99)),99,ROW($2:$99)),ROW(A1)))&""

C2:E2 下拉{=IF(B2="","",T(OFFSET($A$1,SMALL(IF($A$2:$A$99=$B2,ROW($2:$99),99),COUNTIF($B$2:$B2,$B2))+COLUMN(A1)-1,))&"")