不规则两列数据拆分为多行多列 (9595)

  D3:D6{=INDEX(B:B,SMALL(IF(A$3:A$29=D$2,ROW($3:$29),99),ROW(A1)))&""

E3:K6{=IFERROR(VLOOKUP(E$2,OFFSET($A$2:$B$2,MATCH($D$2&$D3,$A$3:$A$20&$B$3:$B$20,),,9),2,),"")