Row wise sorting

[ali zaib]

we can sort data in column , can we sort data in rows i mean sort data in rows
like
1 2 3 4 5 1 2 3 4 5
1 1 2 2 3 3 4 4 5 5

 

[mikerickson]

The Sort dialog box has an Options button that lets you sort left to right or top to bottom

 

[anandvarma]

The Sort dialog box has an Options button that lets you sort left to right or top to bottom

or otherwise

transpose the row data to column and sort it in normal way
and again re-transpose in to row data