依分數 S型分組 (15289)

G1:L1=IF(COLUMN(A1)>$E2,"",COLUMN(A1)&" 組")

G2:L8{=IF(G$1="","",IFERROR(INDEX($B:$B,RIGHT(LARGE($C$2:$C$21/1%+ROW($2:$21),(ROW(A1)-1)*$E$2+COLUMN(A1)+IF(MOD(ROW(A1),2),,$E$2+1-COLUMN(A1)*2)),2)),""))

G12:L18=IF(G2="","",VLOOKUP(G2,$B:$C,2,))