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

"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
>

[David McRitchie]

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" <[email protected]> wrote in message news:[email protected]...
> 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
>

[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 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

This is a pre-butchered up answer to the question as I saw it!

[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.
--
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
> >

[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

"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
>
>

[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

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
> >

[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.