convert columns into rows and columns
 

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

Thanks for your help
--
602 952 2526

convert columns into rows and columns
 

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

convert columns into rows and columns
 

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

"McDuck" wrote:

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

Thanks for your help
--
602 952 2526