NukedWhale
01-07-2009, 01:38 PM
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?
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?