The macro recorder with a manual copy , pastespecial transpose is a good
recommendation - here is another if it fits your requirements.

Range("A2:A27").Value=Application.Transpose(Range( "A1:Z1"))

If you don't need formats and the cells contain constants or you don't want
constants not formulas.

--
Regards,
Tom Ogilvy

"Randy Lefferts" wrote in message
...
I have data in a range A1:Z1. I want to copy this data to
a column, A2:A27. Suggestions or help is most
appreciated! Thank you for your time.

Randy