How to get these cells into 1 column

C

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
 
C

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
 
D

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

oldchippy

Chris said:
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 :
 
T

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
 
P

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
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Payment calculation 1
LOOKUP 1
LOOKUP function 0
Help please - Lookup required - not sure! 1
simple formula I'm sure using offset? or index? 2
Possible? 1
Number range as a percentage 2
Limit on Logic 8

Top