How to get these cells into 1 column

[Chris]

Any ideas how to get this format of numbers into 1 column?

0 25 50 75 100 I would like this: 0
125 150 175 200 225
25
300 325 350 375 400
50

75.....etc

 

[Chris]

Okay that post was butchered up. Here's what it should look like.

0 25 50 75 100
125 150 175 200 225
250 275 300 325 350

Here's what I want:
0
25
50
75
100
....etc

 

[David McRitchie]

see JOIN macro in
http://www.mvps.org/dmcritchie/excel/excel.htm

You will have text in the cell when done.

 

[Dave F]

Select the first row, copy, paste special, transpose.

Repeat for all rows.

Depending on how many rows you need to do that to you may need to write a
macro to automate the process.

 

[oldchippy]

Any ideas how to get this format of numbers into 1 column?

0 25 50 75 100 I would like this
0
125 150 175 200 225
25
300 325 350 375 400
50

75.....etc

Hi Chris,

Play around with this,
0 in cell A1, 25 in A3, then select A1:A4 and copy this down column
to as far as your numbering goes.
Then 125 in cell B2, 150 in cell C2, copy over to F2
Then in G2 put this formula
=CONCATENATE(B2," ",C2," ",D2," ",E2," ",F2)
carry on with this down to the fourth row, then you can drag/copy down
When you have done this you can copy paste, value only and delet
column B:F

Let me know how you get on

oldchippy :

 

[Toppers]

Assuming data in Sheet1 starting in A1 and there are 5 columns:

put in A1 in Sheet2 and copy down

=OFFSET(Sheet1!$A$1,INT((ROW()-1)/5),MOD(ROW()-1,5),1,1)

Change 5 in above to number of columns (per row) if required

HTH

 

[Pete_UK]

As your numbers increase by 25 each time, you could enter 0 in the
first cell and highlight this down to your bottom cell, then use Edit |
Fill | Series and specify linear with an increment of 25.

Hope this helps.

Pete

 

[David McRitchie]

okay after you reposted what you wanted that can be
seen you want to use transpose as "Dave F" said,
but you don't need to do hem one row at a time.