Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how paste transpose reverse?
Thanks for any help.
When I paste special transpose, the left columns go to the top of the pasted rows, and the right columns go to the bottom of the pasted rows. Is there a simple way to reverse this? Right now it's only 10-20 columns, but I was thinking about when it's a couple hundred. Thanks alot. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how paste transpose reverse?
Insert a row at top and fill from 1 to the number of columns you have
Transpose First row will be in first col. Sort descending and then delete the first col. "Ian Elliott" wrote: Thanks for any help. When I paste special transpose, the left columns go to the top of the pasted rows, and the right columns go to the bottom of the pasted rows. Is there a simple way to reverse this? Right now it's only 10-20 columns, but I was thinking about when it's a couple hundred. Thanks alot. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how paste transpose reverse?
Thanks Sheeloo!
"Sheeloo" wrote: Insert a row at top and fill from 1 to the number of columns you have Transpose First row will be in first col. Sort descending and then delete the first col. "Ian Elliott" wrote: Thanks for any help. When I paste special transpose, the left columns go to the top of the pasted rows, and the right columns go to the bottom of the pasted rows. Is there a simple way to reverse this? Right now it's only 10-20 columns, but I was thinking about when it's a couple hundred. Thanks alot. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I transpose the figures to go in reverse order in a bar gr. | Charts and Charting in Excel | |||
paste in Reverse Order | Excel Discussion (Misc queries) | |||
In Excel: add a Paste-Special Option to paste IN REVERSE ORDER. | Excel Worksheet Functions | |||
reverse cut and paste | Excel Worksheet Functions | |||
How can I transpose a paste link? | Excel Discussion (Misc queries) |