Sorry this will not work for me. Iam getting this same result in all the methods iam trying. But actually i want the system to somehow rearrange the rows so that when two rows in second column have the same values it needs to come together and the order of first column should not change(i mean it should have all 1 values at top and subsequently 2 values or more at bottom).
Here we cannot use the ascending or descending logic in second or third column since it is not based upon that.
Also please note that each group in first column will have two unique values alone in the second column.
For eg
GN JMBWN Name
1 g5yi Adwin
1 g5yi John
1 7rte Morris
2 g5yi Renold
2 8ert Manu
2 8ert Sam
Here there are two groups, 111 and 222,
Inside these groups there are 2 unique values in second column for each group.
One specific value from second column can repeat any number of time in any group. Lets assume in this case that value is “g5yi”. In my previous example that was “BBBB”.
It can also happen that there are no instances of this repeat value also.
I want the groups to maintain numerical order, like it should come as 111 then 222, but also the second column whenever the values are same should come in rows together.
The result of this should look like this.
GN JMBWN Name
1 7rte Morris
1 g5yi Adwin
1 g5yi John
2 g5yi Renold
2 8ert Manu
2 8ert Sam
Please note that this is only a rearrangement of the rows and there can be many columns after this. It should not change any values in a particular row, we can only rearrange the rows.
It will be really helpfull if i can get a solution for this.