Sheeloo wrote:

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" wrote:

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?

--
Terry, East Grinstead, UK


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)

--
Terry, East Grinstead, UK