McDuck wrote:
I need to convert 10,000 item single column into 1,000 rows and 10 columns

Thanks for your help
If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook

=ArrayReshape(a1:a10000,1000,10) or
=ArrayReshape(a1:a10000,1000,10,1) array entered into a range of 1000
rows and 10 columns. Which you use depends on whether you want the
value from A2 or A1001 to start the second column; you didn't specify.

Alan Beban