同名稱相聚 且插入一行 (14241)

D2=INDEX(A:A,SMALL(IF((MATCH(A$2:A$7,A:A,)=ROW($2:$7))*(COUNTIF(A:A,A$2:A$7)+1>=COLUMN(A:I)),ROW($2:$7),9),ROW(A1)))&""

E2=IFERROR(INDEX(B:B,SMALL(IF(A$2:A$7=D2,ROW($2:$7)),COUNTIF(D$2:D2,D2)-1)),"")