Is there a way to sort columns

[SmilingPolitely]

I am familiar how to sort data in columns e.g.

oranges apples
2 8
3 7
1 5

sorting by oranges returns
oranges apples
1 5
2 8
3 7

and by apples B etc..

BUT is it possible to sort the columns themselves into alphabetical
order? returns

apples oranges
8 2
7 3
5 1


Any help would be appreciated.

 

[SmilingPolitely]

I am familiar how to sort data in columns e.g.

oranges apples
2 8
3 7
1 5

sorting by oranges returns
oranges apples
1 5
2 8
3 7

and by apples B etc..

BUT is it possible to sort the columns themselves into alphabetical
order? returns

apples oranges
8 2
7 3
5 1


Any help would be appreciated.

dont worry. got it.

 

[R.VENKATARAMAN]

in the data-sort window click options and click <sort left to right> and
normal and choose <row1)
(assuming texts oranges and apples are in first row.)