拆分多格多明細 (15333)

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

H2:J2 下 拉=IF($G2="","",TRIM(MID(SUBSTITUTE(VLOOKUP($G2,$A:$E,COLUMN(B1),),",",REPT(" ",99)),COUNTIF($G$2:$G2,$G2)*99-98,99)))

K2=IF(G2="","",VLOOKUP(G2,A:E,5,))