不同班级 空白隔開 (14236)

(先)H2{=INDEX(B:B,SMALL(IF((MATCH(B$2:B$15,$B:$B,)=ROW($2:$15))*(COUNTIF(B:B,B$2:B$15)+J$2>=COLUMN(A:I)),ROW($2:$15),99),ROW(A1)))&""

(後)G2{=IFERROR(INDEX(A:A,SMALL(IF(B$2:B$15-H2=0,ROW($2:$15)),COUNTIF(H$2:H2,H2))),"")