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