單格數人 分別提取 (12950)

D2{=INDEX(A:A,SMALL(IF(LEN(B$2:B$4)-LEN(SUBSTITUTE(B$2:B$4,",",))+1>=COLUMN(A:Z),{2;3;4},99),ROW(A1)))&""

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