單格多字符 拆成一行 (14169)

(先)F2{=INDEX(C:C,SMALL(IF(LEN(B$2:B$6)-LEN(SUBSTITUTE(B$2:B$6,"、",))+1>=COLUMN(A:I),ROW($2:$6),99),ROW(A1)))&""

(後)E2=IF(F2="","",TRIM(MID(SUBSTITUTE(VLOOKUP(F2,IF({1,0},C$2:C$6,B$2:B$6),2,),"、",REPT(" ",99)),COUNTIF(F$2:F2,F2)*99-98,99)))