I'm not clear, did 2nd column is unique ?
I've found some duplicate of 2nd column in 'Sorting' sheet.

Could you please show your 'fake but similar to real data' and desired output?

Regards.