| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Instructions to convert columns to rows Excel help are not correct | Excel Worksheet Functions | |||
| convert columns to rows & rows to columns | Excel Discussion (Misc queries) | |||
| How can i convert the rows into columns and columns into rows? | Excel Worksheet Functions | |||
| Convert data from rows to columns | Excel Discussion (Misc queries) | |||
| Convert multiple columns to rows | Excel Worksheet Functions | |||
Hybrid Mode
