EXCEL中如何是将横向变为纵向答:A9 =INDEX($A$3:$B$4,ROUNDUP((ROW(A1))/5,0),COLUMN(A2)) 向右复制到 B9 C9 =INDEX($C$2:$G$2,1,IF(MOD(ROW(A1),5)=0,5,MOD(ROW(A1),5)))D9 =INDEX($C$3:$G$4,ROUNDUP(ROW(A1)/5,0),IF(MOD(ROW(B1),5)=0,5,MOD(ROW(B1),5)))然后一起选中 A9、B9...
EXCEL中如何是将横向变为纵向答:A9 =INDEX($A$3:$B$4,ROUNDUP((ROW(A1))/5,0),COLUMN(A2))向右复制到 B9 C9 =INDEX($C$2:$G$2,1,IF(MOD(ROW(A1),5)=0,5,MOD(ROW(A1),5)))D9 =INDEX($C$3:$G$4,ROUNDUP(ROW(A1)/5,0),IF(MOD(ROW(B1),5)=0,5,MOD(ROW(B1),5)))然后一起选中 A9、B9、C9...