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

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

"Chris" wrote:

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

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

You will have text in the cell when done.
--

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Chris" wrote in message ...
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

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.
--
Brevity is the soul of wit.


"Chris" wrote:

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

"Chris" wrote:

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 Wrote:
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 A
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 delete
column B:F

Let me know how you get on

oldchippy :)


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
View this thread: http://www.excelforum.com/showthread...hreadid=573238

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

"oldchippy" wrote:


Chris Wrote:
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 A
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 delete
column B:F

Let me know how you get on

oldchippy :)


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
View this thread: http://www.excelforum.com/showthread...hreadid=573238

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

Chris wrote:
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

"Chris" wrote:

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

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.