200 rows, first column contains a unique text name eg "Smith"
In the "Smith" row for example, the other columns are filled with 3 serial numbers eg 56,58,72
But in the "Jones" row, there are the same serial numbers but in a different order, 72, 58,56 plus 2 other numbers, 88 and 99
This continues down the rows...
My question is, can I sort each row so that one serial number eg. 56 appears in the first column , 58 in the next, etc etc.
Apologies if this is a bit confused....
In the "Smith" row for example, the other columns are filled with 3 serial numbers eg 56,58,72
But in the "Jones" row, there are the same serial numbers but in a different order, 72, 58,56 plus 2 other numbers, 88 and 99
This continues down the rows...
My question is, can I sort each row so that one serial number eg. 56 appears in the first column , 58 in the next, etc etc.
Apologies if this is a bit confused....
