Change row of numbers to column of numbers

Microsoft Office:mac 2008 home and stude...
July 15, 2010 at 06:11:09
Specs: Macintosh
I have one row of numbers, separated by spaces, that I need to be in a column, each on individual row lines.

For example, in Excel, on the first row is the following list of numbers:

2517 3704 5428 4522 2409 6140 ...

I need to find a way to convert the row of numbers into a column of numbers. The individual space denotes the end of the number. I'd need to have the numbers be listed on separate rows, in one column:

2517
3704
5428
4522
2409
6140
...

If you can, please help! Thanks.


See More: Change row of numbers to column of numbers

Report •


#1
July 15, 2010 at 06:21:35
Hi,

Select the cells in the row.
Right-click and Copy
Select the first cell where you want the cells to go as a column (cannot be a cell in the row of cells you are copying)
Right-click this cell and select 'Paste Special..'
In the dialog box that opens check the 'Transpose' box and click OK.

You can then delete the original row of cells.

Hope this is what you wanted.

Regards


Report •

#2
July 15, 2010 at 07:37:32
Perfect! You've helped a tremendous amount, thanks!

:)


Report •

#3
July 15, 2010 at 08:08:37
You're welcome

Regards

Humar


Report •

Related Solutions


Ask Question