两ç§åæ³ï¼é»ç»¿ï¼èªå·±é
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(COUNTA($A$2:$A$20)/3,0)))&""
G2=INDEX($A:$A,ROW(A1)*2+COLUMN(A1)-1)&""
I2=INDEX($A:$A,ROW(A1)*3+COLUMN(A1)-2)&""
ä¸è¿°å
¬å¼åå³åä¸å¤å¶