Move data from column to rows HELP!!!

G

greenfalcon

Hi thanks for taking the time to look at my problem, currently i have
column that has thousands of rows of information in it, it looks lik
this


A

40432
432654
3432
532543
32432
523
53425
532532
532
523
532
111
222
333
666

numbers that go on into mabye the 5000-6000 range

what i need to do is have that data moved So it looks like this

A | B | C

40432 | 32432 | 532
432654 | 523 | 523
3432 | 52432 | 111
532543 | 532532 | 222

So on and so on,

so instead of 1 column with 6000 lines it would have

200 columns each with 25 rows

something like that

anyone have any ideas i have exausted my knowlege and could not get i
to work.

Thank
 
M

mzehr

Hi

Assuming that your data starts in row 1 on sheet1
insert the following formula=OFFSET(Sheet2!$A1,(COLUMN(A1)-
1)*25,0) into sheet 2 row 1 and copy down 25 times and
across 200 or so times until all your data is copied.
HTH
 
G

greenfalcon

When i try using the code camilo wrote and i type it in just a
described it starts with the value of a27 and goes on from there, whe
i copy the code between rows it continues to work, however i need it t
start with a1,

as for mzehr

when i type in your code it starts with the value of A1 but when i cop
it between rows it starts back at a1

i need it to continue a1-300 etc between rows

thank
 
G

greenfalcon

OHH SO CLOSE!!!!

Mehzer your code is so close to what i need here is what happens, i a
testing it and it does this

say i have this a single colum like this

a
b
c
d
e
f
g

here is what your code is doing, when i type in i want it to hav
columns of 3 it does this

a | c | e |
b |d | f |
c |e | g |

it is duplicated the last on the line and the first on the new line yo
kow what could be doing this??

Thanks

Gree
 
G

greenfalcon

You guys are awsome it works wonders, i dont know how it works but il
do some researching to figure this out.

This will end up saving my company Hours and hours of time and make i
much easier to create specific graphs thanks so much

Jaso
 
M

mzehr

Hi Green,
I'm not sure why you are getting those results. I filled
column A from row 1-3500 with numbers ranging from 1-3500,
went to sheet one, copied that formula into the range
A1:O25 to test it out and no problems. It is specifically
written to give you 25 rows of data. Maybe headers on
sheet1 are getting in the way?

Good luck.
 
Top