I don’t think there is any reliable algorithm to fulfill your requirement.
E.g. below input data can’t be sorted according your requirement
1,DDDD,Arun
1,BBBB,Ashwin
1,CCCC,Vishwa
2,BBBB,Sam
2,DDDD,John
2,DDDD,Jain
Cheers
1 Like