Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Transpose Funtion
Does anyone know the max number of rows and columns (range) the transpose
function can convert? I have a large verticle dataset I want to turn horizontal. 15,000 - 30,000 rows and 40 columns. Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Transpose Funtion
On Fri, 28 Nov 2008 18:21:01 -0800, Mimi
wrote: Does anyone know the max number of rows and columns (range) the transpose function can convert? I have a large verticle dataset I want to turn horizontal. 15,000 - 30,000 rows and 40 columns. Thanks! I don't know much about this process, but I am aware of the following: Depending on how you are doing this, you may run into certain limitations. For array size problems, see MSKB Q177991 Also, there can be issues if any element is greater than 255 characters. Also, prior to XL2007, XL had 256 columns. Even XL 2007 has only 16,384 columns which is fewer than the number of possible rows (30,000) in your dataset. --ron |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Transpose Funtion
Hi,
You can't transpose 15,000 rows into columns unless you are using 2007, but there are only 16,384 columns so that the max number of rows that could be transposed. I have verified that =TRANSPOSE(Range) will transpose 16,384 rows to columns. However, it runs into a problem somewhere between 81,920 - 98,304 cells. The Transpose command has a limit somewhere between 114,618 - 131,002 cells. This limit might be related to the available resources on my computer. If this helps, please click the the Yes button Cheers, Shane Devenshire Cheers, Shane Devenshire "Mimi" wrote: Does anyone know the max number of rows and columns (range) the transpose function can convert? I have a large verticle dataset I want to turn horizontal. 15,000 - 30,000 rows and 40 columns. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Funtion | Excel Worksheet Functions | |||
If Funtion | Excel Worksheet Functions | |||
I WANT TO TRANSPOSE LINKS, AS WE TRANSPOSE VALUES | Excel Worksheet Functions | |||
If funtion help | New Users to Excel | |||
IF funtion | Excel Discussion (Misc queries) |