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