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.

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

Perfect! You've helped a tremendous amount, thanks! :)

You're welcome Regards

Humar

Ask Your Question

Weekly Poll

Do you trust smart speakers to not spy on you?

Discuss in The Lounge

Poll History