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