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.