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)