拆 單格多個自動換列數據 (14612)

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

F2=IF(E2="","",TRIM(MID(SUBSTITUTE(VLOOKUP(E2,B:C,2,),CHAR(10),REPT(" ",99)),COUNTIF(E$2:E2,E2)*99-98,99)))