Perhaps a formula would help
if your range is from A1:A4
and you need the values to appear say from B1:E1
then on B1 typr this and copy across thru E1

=OFFSET($A$4,2-COLUMN(),0)


"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