如图所示,如何将表格形势转换成两列显示
A2è¾å ¥
=IF(ISODD(COLUMN()),OFFSET($D$2,MOD(ROW(A1)-1,3),)&OFFSET($E$1,,(ROW(A1)-1)/3),OFFSET($E$2,MOD(ROW(A1)-1,3),(ROW(A1)-1)/3))
å ¬å¼å³æä¸æ