Hello all,

I don't seem to understand Transpose.

I have a set of data 10 columns in length, cells A1 - J1. All I want
to do is have a formula take this line and transpose it downwards.

I have tried:

=transpose($A$1:$J$1)
=transpose(A1:J1)
{=transpose($A$1:$J$1)}

.....

It simply will not transpose my data. Do I have this set up correctly?
Do I need my data on the right side of my formula?

I should note that copy - past special - transpose works fine, but
this needs to be automated.

Thanks
-SD