在excel表中,有很多数据,6000多条,我怎么分成2列或者3列?例图看图,答:两种分法(黄绿)自己选 B2=IF(ROW(A1)>ROUNDUP(COUNTA($A$2:$A$20)/2,0),"",INDEX($A:$A,ROW(A2)+(COLUMN(A1)-1)*ROUNDUP(COUNTA($A$2:$A$20)/2,0)))&""D2=IF(ROW(A2)>ROUNDUP(COUNTA($A$2:$A$20)/3,0),"",INDEX($A:$A,ROW(A3)+(COLUMN(A2)-1)*ROUNDUP(...