How to use =transpose function

[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.

[Harlan Grove]

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.

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.

[Domenic]

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!

In article <[email protected]>,
"Hall" <[email protected]> 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.

[latch135]

I am having trouble with the Transpose function. I understand what is required for an array. This what I get:
Hours
$0.35
$0.33
$0.34
$0.31
$0.27
#N/A

I figured it out.