自動換列 單格多數據 拆開 (13848)

D1{=INDEX(A:A,SMALL(IF(LEN(B$1:B$19)-LEN(SUBSTITUTE(B$1:B$19,CHAR(10),))>=COLUMN(A:I),ROW($1:$19),99),ROW(A1)))&""

E1=IF(D1="","",TRIM(MID(SUBSTITUTE(VLOOKUP(D1,A:B,2,),CHAR(10),REPT(" ",99)),COUNTIF(D$1:D1,D1)*99,99)))