transposing numbers.

R

Rimma

I wonder if anyone can help.
I have a list of numbers that are sorted in numerical
order. I typed them from up to botom. I would like to
display them horizontally instead.
For example, they look like this:
1
2
3
4
5
I would like them to look like this:
1 2 3 4 5

Can someone help?

Thanks in advance
 
P

Paul

Rimma said:
I wonder if anyone can help.
I have a list of numbers that are sorted in numerical
order. I typed them from up to botom. I would like to
display them horizontally instead.
For example, they look like this:
1
2
3
4
5
I would like them to look like this:
1 2 3 4 5

Can someone help?

Thanks in advance
Click to expand...

Copy the vertical list of numbers. Click on the cell where you want the
first number to be and use Edit > Paste Special > Transpose.
 
Top