Prev: The whole page moves with the up/down arrows, not the cells
Next: Formula For Time Duration Calculation
From: Doan Winkel on 20 Mar 2010 21:13
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
From: Alejandro Medinilla "elMedex" on 20 Mar 2010 23:38
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
From: Roger Govier on 21 Mar 2010 07:55
Hi Doan

XL2007 has a limit of 16,384 columns so you cannot do that.

You could select 16,000 rows, copy>Patse Special>Transpose 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
 | 
Pages: 1
Prev: The whole page moves with the up/down arrows, not the cells
Next: Formula For Time Duration Calculation