Match 2 columns import 3rd

See attached.

You would need to make a unique list of Branches in y-axis

and unique Distance Ranks (but 2 of each)

Then in G4:

=IF(ISNUMBER(MATCH(1,INDEX(($A$2:$A$33=$F4)*($B$2:$B$33=G$2),0),0)),INDEX($C$2:$C$33,MATCH(1,INDEX(($A$2:$A$33=$F4)*($B$2:$B$33=G$2),0),0)),"")

and in H4:

=IF(ISNUMBER(MATCH(1,INDEX(($A$2:$A$33=$F4)*($B$2:$B$33=H$2),0),0)),INDEX($D$2:$D$33,MATCH(1,INDEX(($A$2:$A$33=$F4)*($B$2:$B$33=H$2),0),0)),"")

copy both down.

Then copy those 2 columns and paste to each other Distance/Group columns.