Vir,

I think you want each individual row put into consecutive order, left to
right, without regard to any other row.  If so, you'll have to select the
rows one at a time, and do a sort on each.  The quick-sort toolbar buttons
are wired to sort only vertically, so they won't do.  You'll have to use
Data - Sort.  Any sort command is likely to result in "Excel found data next
to your selection..."   You should opt not to expand the selection, but to
continue with the current selection.  In the Data - Sort dialog, use
"Options" and opt for left-to-right sorting, as I think you're doing.  A
macro could automate this.

Another possible solution is formulas in a separate table to present the
data as you want.