convert columns into rows and columns

M

McDuck

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

Thanks for your help
 
A

Alan Beban

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

Thanks for your help
Click to expand...
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
 
T

Toppers

A liitle more explanation as to how the data is organised (input/output)
might be helpful.
 
Top