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 |
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) |