排列 S型或蛇型 (9949)

A1:J1=IF(COLUMN(A1)>$L2,"","数据"&COLUMN(A1))

A2:J2 下拉=IF(COLUMN(A1)>$L$2,"",(ROW(A1)-1)*$L$2+COLUMN(A1)+MOD(ROW(A2),2)*($L$2+1-COLUMN(A1)*2))

列數5 可=-1^MOD(ROW(),2)*COLUMN()+INT(ROW(B1)/2)*10+MOD(ROW(),2)