Hello,

I have a worksheet with several thousand rows of data. The particular data I need to sort is in 4 columns. Data is stored as numbers and there are occasional empty cells.

Using a comma as a delimiter, here's an example of what my data looks like

100,102,103,101
104,102,103,101
100,102,103,,
104,102,,,

I need to sort each row left to right in ascending order and I need each row to be sorted independently. Blank or empty cells should be placed to the right.

Excel has a built in horizontal sort ability but I can't sort multiple rows independently. By this I mean that if I select the entire array and sort by row 1, rows 2-2000 will be rearranged in the exact same fashion.

Can anyone help?