How to use =transpose function

  • Thread starter Thread starter Hall
  • Start date Start date
H

Hall

My first row has the values 1,2, and 3 respectively starting in A1.

I want A2 to be the start of the same array but vertically. That's the
transpose function.

So I put =transpose(A1:C1) in A2. The result is I got 1 in A2. The other
values were brought over.

What am I doing wrong? I also tried =transpose($A$1:$C$1) like the example
in the help text.
 
Hall wrote...
My first row has the values 1,2, and 3 respectively starting in A1.

I want A2 to be the start of the same array but vertically. That's the
transpose function.

So I put =transpose(A1:C1) in A2. The result is I got 1 in A2. The other
values were brought over.

What am I doing wrong? I also tried =transpose($A$1:$C$1) like the example
in the help text.
Click to expand...

First select A2:A4, either by clicking on cell A2, holding down the
'left' button and dragging down to cell A4 or moving to cell A2,
holding down a [Shift] key and pressing the down arrow key twice. Then
type the formula

=TRANSPOSE(A1:C1)

hold down [Crtl] and [Shift] keys and then press [Enter]. This creates
what's called an array formula in A2:A4.
 
Before entering your formula, select cells A2:A4. Then, with those
three cells highlighted, enter your formula and confirm with
CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!
 
Back
Top