This topic has been archived. It cannot be replied.
-
工作学习 / 专业知识杂谈 / EXCEL 问题, 如何用公式把一列数转成一行数?我知道如何COPY+SPECIAL PASTE+TRANSPOSE实现. 但我的数据每个月都要更新, 我想用公式自动转换.
-shelley57(shelley);
2006-11-17
(#3325669@0)
-
record a macro?
-hrm(CCP);
2006-11-17
(#3325726@0)
-
try MACRO
-6bear6(maple bear);
2006-11-17
(#3325727@0)
-
array function {transpose}
-little5(没事小心，有事大胆);
2006-11-17
(#3325853@0)
-
easy! copy + paste, transpose, record macro, 看看语法长啥样。
-chenrulai(BlueSky);
2006-11-18
(#3326562@0)
-
highlight the whole row, type =transpose(column), click shift ctrl enter.
-jeffrey815(Smartiecat);
2006-11-18
(#3326572@0)
-
终于搞清楚如何实现(A15:A26):CELL'A15'=TRANSPOSE(A1:L1)+F2+CTL+SHIFT+ENTER, 但新的问题有出来: 我想加入一个条件, 就是如果ANY CELLS IN (A14:L14)小于数字10那么我就TRANPOSE 对应CELLS IN (A1:L1)过来, 否则就用#N/A来代替. 但怎么试都无法实现.
-shelley57(shelley);
2006-11-18
(#3327080@0)
-
{=IF(OR(A1<10, B1<10,....., L1<10), "NA", TRANSPOSE(A1:L1))}
-little5(没事小心，有事大胆);
2006-11-18
(#3327447@0)