Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transpose Large Column to Row
Hi -
I have a column with about 25,000+ rows in Excel 2007, and need to somehow get this transposed into a row (so with 25,000+ columns). I have tried to do this with the TRANSPOSE function using Ctrl-C and using the Paste drop-down menu and selecting the Transpose option. But I get an error message that the copy area and paste area are not the same size. I presume this is because I cannot paste across 25,000+ columns? Basically, in the end, what I want to have is a list of each cell with a semicolon after each but am just not sure how to do this. Any suggestions would be greatly appreciated. Thanks Doan |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transpose Large Column to Row
Hello
Have you tried with Concatenate formula?? lets pretend that you have all your values in colum A from A1 to A[N] so on B1 use this fomula =A1 and on b2 this one =CONCATENATE(B1,";",A2) and copy the formula until B[N] so you have an output like this A B 1 a a 2 b a;b 3 c a;b;c 4 d a;b;c;d 5 e a;b;c;d;e 6 f a;b;c;d;e;f Hope it works Regards elMedex "Doan Winkel" wrote: Hi - I have a column with about 25,000+ rows in Excel 2007, and need to somehow get this transposed into a row (so with 25,000+ columns). I have tried to do this with the TRANSPOSE function using Ctrl-C and using the Paste drop-down menu and selecting the Transpose option. But I get an error message that the copy area and paste area are not the same size. I presume this is because I cannot paste across 25,000+ columns? Basically, in the end, what I want to have is a list of each cell with a semicolon after each but am just not sure how to do this. Any suggestions would be greatly appreciated. Thanks Doan |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transpose Large Column to Row
Hi Doan
XL2007 has a limit of 16,384 columns so you cannot do that. You could select 16,000 rows, copyPatse SpecialTranspose and then select the other 9,000 rows and do the same thing on a different row. -- Regards Roger Govier Doan Winkel wrote: Hi - I have a column with about 25,000+ rows in Excel 2007, and need to somehow get this transposed into a row (so with 25,000+ columns). I have tried to do this with the TRANSPOSE function using Ctrl-C and using the Paste drop-down menu and selecting the Transpose option. But I get an error message that the copy area and paste area are not the same size. I presume this is because I cannot paste across 25,000+ columns? Basically, in the end, what I want to have is a list of each cell with a semicolon after each but am just not sure how to do this. Any suggestions would be greatly appreciated. Thanks Doan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transpose large column | Excel Discussion (Misc queries) | |||
Needs to Transpose Large List | Excel Discussion (Misc queries) | |||
how to transpose a large data from columns into rows | Excel Discussion (Misc queries) | |||
how to transpose a large data from columns into rows | Excel Discussion (Misc queries) | |||
How can I transpose rows to columns in a large worksheet? | Excel Discussion (Misc queries) |