Sorting fishing data in 2 sectors

[Catvisser]

Best,
In our fishing club we want to use a different way of sorting competition data from this year onwards. Normally we just sort by weight from highest to lowest. Now we work with 2 sectors and we want to sort according to a different principle. 1st sector A, 1st sector B, 2nd sector A, 2nd sector B in case if sector A has the heighest weight. Otherwise it's first sector B, first sector A, seconde sector B, second sector A, ...

Now we just used the sort function from largest to smallest, but in this case this is a little more complicated to sort automatically. I have some basic knowledge of Excel, but I am unable to do this. Is there anyone who can help me with this? Thank you very much!

Check example in attachement.