Hi Davis,

the edit paste specialtranspose command can logically copy values and
formats...

while the transpose function links the transposed data from its source...
for ten cells in a column...
select 10 cells in a row
then
type either in the first or last cell =transpose(A1:J1
then press control-shft-enter
the { } braces will appear and see if the data were correctly transpose in
order.

regards
--
*****
birds of the same feather flock together..



"S Davis" wrote:

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