how paste transpose reverse?

[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.

 

[Sheeloo]

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]

Thanks Sheeloo!

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.