Reverse worksheet data by columns

[Bruce]

I have a worksheet with data, lets say from columns A:Z.
I would like to flip this data by columns only. eg Z becomes A, Y becomes B,
X becomes C etc.

I'm thinking I should link it to a new sheet and adjust by formula. Can
anyone help.
Any other ideas also appreciated.

Bruce

[Dav]

Just sort the columns, Choose data_sort and in your options you can sort left to right rather than top to bottom which is the default.

Regards

Dav

[Bruce]

Great, thanks Dav

"Dav" wrote:

>
> Just sort the columns, Choose data_sort and in your options you can sort
> left to right rather than top to bottom which is the default.
>
> Regards
>
> Dav
>
>
> --
> Dav
> ------------------------------------------------------------------------
> Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
> View this thread: http://www.excelforum.com/showthread...hreadid=560564
>
>

[Gord Dibben]

You may want to re-think this.

Dav's suggestion works fine if the data from Column A to Z is already
alphabetically arranged.

If not, perhaps you could try entering the numbers 1 to 26 across A to Z and
sort left to right on them.


Gord Dibben MS Excel MVP

On Wed, 12 Jul 2006 00:08:01 -0700, Bruce <[email protected]>
wrote:

>Great, thanks Dav
>
>"Dav" wrote:
>
>>
>> Just sort the columns, Choose data_sort and in your options you can sort
>> left to right rather than top to bottom which is the default.
>>
>> Regards
>>
>> Dav
>>
>>
>> --
>> Dav
>> ------------------------------------------------------------------------
>> Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
>> View this thread: http://www.excelforum.com/showthread...hreadid=560564
>>
>>