G gilg Mar 18, 2004 #1 Hi, can someone help me use the transpose function I can't seem to ge good results. I'm trying to divert a column of numbers to a line
Hi, can someone help me use the transpose function I can't seem to ge good results. I'm trying to divert a column of numbers to a line
B Bernie Deitrick Mar 18, 2004 #2 gilg, If you want to trasnpose A1:A10, select a 10 column wide row of cells, say B1:K1, type in =TRANSPOSE(A1:A10) and use Ctrl-Shift-Enter to enter it as an array formula. HTH, Bernie MS Excel MVP
gilg, If you want to trasnpose A1:A10, select a 10 column wide row of cells, say B1:K1, type in =TRANSPOSE(A1:A10) and use Ctrl-Shift-Enter to enter it as an array formula. HTH, Bernie MS Excel MVP
G Gord Dibben Mar 18, 2004 #3 An alternative to the TRANSPOSE Function can be Copy>Paste Special>Transpose. Gord Dibben Excel MVP gilg, If you want to trasnpose A1:A10, select a 10 column wide row of cells, say B1:K1, type in =TRANSPOSE(A1:A10) and use Ctrl-Shift-Enter to enter it as an array formula. HTH, Bernie MS Excel MVP Click to expand...
An alternative to the TRANSPOSE Function can be Copy>Paste Special>Transpose. Gord Dibben Excel MVP gilg, If you want to trasnpose A1:A10, select a 10 column wide row of cells, say B1:K1, type in =TRANSPOSE(A1:A10) and use Ctrl-Shift-Enter to enter it as an array formula. HTH, Bernie MS Excel MVP Click to expand...
