Breaking a col into smaller parts

[gilbert]

I have a col of names in col A. there are 7000 or more. I need a formula or method to break out into groups of 500 each and paste each 500 group into col b c d e f g and so on.

Thanks

Galen

 

[DonkeyOte]

I think you're saying they are in unique rows (ie 7000 rows rather than 7000 names in one cell!)

assuming they appear in A1:A7000

TO get 1 to 500 in B1:B500

set formula in B1 = OFFSET($A1,0+(500*(COLUMN(B1)-2)),0)

copy B1 through to B500 then copy B1:B500 and paste in C1, D1, E1, F1 etc...

Once complete copy your final range (eg B1:O500 for 7000 cells exactly) and paste into B1 as values only (ie override formulae)

 

[Jonmo1]

Try this in B1 Filled right and down as needed.

=INDEX($A:$A,ROWS(A$1:A1)+(500*(COLUMNS($A1:A1)-1)))

Hope that helps..