how paste transpose reverse?

  • Thread starter Thread starter Ian Elliott
  • Start date Start date
I

Ian Elliott

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.
 
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.
 
Thanks Sheeloo!

Sheeloo said:
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.
Click to expand...
 
Back
Top