You could use a "helper" column where you number the adjacent cells 1 to 4.
Then, simply select both columns, and sort on the helper, descending.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"Ted Metro" wrote in message
...
I know how to use the paste special transpose to move values, but need help
on this.
let's say I have these values in column A, starting at A1.
Alpha
Beta
Gamma
Delta
I want to re-arrange these values such that they go from Delta to Alpha in a
column,
Delta
Gamma
Beta
Alpha
Paste Special Transpose won't do this. Any ideas?
Ted
|