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