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

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

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

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