单元格内容拆分按列展示 (9573)

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

E3=IF(D3="","",TRIM(MID(SUBSTITUTE(VLOOKUP(D3,A:B,2,),",",REPT(" ",99)),COUNTIF(D$3:D3,D3)*99-98,99)))