拆分單格多數據 (14883)

F2:G15{=INDEX(B:B,SMALL(IF(LEN($D$2:$D$6)-LEN(SUBSTITUTE($D$2:$D$6,",",))+1>=COLUMN($A:$Z),ROW($2:$6),9),ROW(A1)))&""

H2:H15=IF(F2="","",TRIM(MID(SUBSTITUTE(VLOOKUP(F2,B:D,3,),",",REPT(" ",99)),COUNTIF(F$2:F2,F2)*99-98,99)))