超过4列就换行 (10397)

M2:M12=OFFSET($A$1,SMALL(IF(INT((MMULT(N($B$2:$J$7<>""),ROW(1:9)^0)-1)/4)+1>={1,2,3,4},$A$2:$A$7,99),ROW(A1)),)&""

N2:Q12=IFERROR(VLOOKUP($M2*1,$A:$J,COUNTIF($M$2:$M2,$M2)*4-3+COLUMN(A1),)&"","")