convert columns into rows and columns

[McDuck]

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

Thanks for your help
--
602 952 2526

[Alan Beban]

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

[Toppers]

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