transposing values top to bottom

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

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" <[email protected]> wrote in message
news:[email protected]...
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

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" <[email protected]> wrote in message
news:[email protected]...
>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

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