View Single Post
  #4   Report Post  
galimi
 
Posts: n/a
Default

Ted,

You can assign sequential numbers in an adjacent column and then sort the
numbers in descending order.

http://HelpExcel.com

"Ted Metro" wrote:

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