Horizontal 'sort'

D

Don Niall

Hi,

I have 3 rows of data - A, B, and C.
A1, B1 and C1 are respective row names. Is it possible to
do a sort on any one of the variable A, B or C - but
sorting horizontally rather than vertically. I tried a few
things but it didn't work correctly ...

Thanks,

Don-
 
K

kkknie

One way is to Copy, Paste Special (Transpose) to get them into columns.
Then do the sort. You can then Copy, Paste Special again to get the
back to rows.
 
D

DDM

Don, click in the data (or select it) and select Data > Sort > Options >
First key sort order = Normal > Orientation = Sort left to right > OK.
Select the row to sort by (a,b,or c in your example) and either Ascending or
Descending. Then OK to do the sort.
 
Top