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

"Terry Pinnell" skrev i meddelelsen
...
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