Horizontal 'sort'

[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-

 

[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.

 

[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.