Paul,

Thank you for that concise, logical instruction. It worked perfectly.

"Paul Corrado" wrote:

Highlight A3:A5

Enter formula

=Transpose(A1:C1)

It is an array function so enter while holding down CTRL+SHIFT+ENTER



"bill_morgan_3333" wrote in
message ...
Friends,

I know how to copy / paste special / transpose, but I cannot get the
TRANSPOSE() worksheet function to work. Let's say I have 1,2,3 in the
horizontal array A1:C1. What, exactly, do I do to transpose the 1,2,3 into
a
vertical array in (A1:A5), using only the TRANSPOSE() worksheet function.

I keep getting the #Value# error, so I must be missing something.

Thanks for your help ...

Bill Morgan