Transpose a col to a row?

[Terry Pinnell]

It's been a while since I last did this and can't immediately get the
hang of using the TRANSPOSE function for it. Could someone help me get
a handle on it please?

I've copied 5 numbers onto the clipboard from elsewhere, in 'vertical'
form. So that on a blank worksheet, if I select A(1) and click Ctl+v I
get them as a vertical column:
1
6
3
20
5

But I actually want them as a row:
1 6 3 20 5

How do I achieve that please?

 

[Per Jessen]

Hello Terry

Once you have copied the numbers into the clipboard and selected the target
cell (A1), goto Edit > PastSpecial and check Transpose > OK

Regards,
Per, Copenhagen, DK

 

[Sheeloo]

Copy the values
then go to where you want the row to start (should not be a part of original
range)
Edit-> Paste Special -> Transpose

 

[Terry Pinnell]

Copy the values
then go to where you want the row to start (should not be a part of original
range)
Edit-> Paste Special -> Transpose

Thanks both. But it appears you can only do that with data copied
*within* Excel, not "from elsewhere". In that case I don't get the
Transpose option under Edit > Paste Special.

I have since achieved my aim, but with an extra step or two involving
writing the following in A2.
=TRANSPOSE(A1:A5)