How does the TRANSPOSE command work?

  • Thread starter Thread starter AJ
  • Start date Start date
A

AJ

For the life of me, i can't figure it out. I've tried
highlighting, not highlighting, i'm just stupid.

if a1:c1 = 1,2,3

and i want a2, a3, a4 = 1, 2, 3, step by step (including
highlighting because I can't get it to work), how would
you use the transpose command? I know...SIMPLE question,
but I can't get it to work for the life of me!!!
 
Hi AJ

easiest option
highlight A1:C1
copy
click on A2
choose edit / paste special
tick the transpose box
press OK

if you REALLY want to use the transpose function (and this is one of the
first things i learnt from this ng!)
then
click in A2
highlight down to A4
type
=TRANSPOSE(A1:C1)
and press CONTROL & SHIFT & ENTER to enter the formula (its an array formula
so just ENTER wont work).

Cheers
JulieD
 
Besides TRANSPOSE(), you might also want to try ..

In A2: =OFFSET($A$1,,ROW(A1)-ROW($A$1))
(press ENTER will do, need not be array-entered)

Copy A2 down to A4
 
Back
Top