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. |
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. |
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. |
All times are GMT +1. The time now is 02:00 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com