How to show a list of top 10 pairing names from far left column and top row

I was trying to figure out a formula that can be used to show a list of the top 10 pairing names, along with their % value, from the far left column and top row based on the % data in the grid like in this example below:

My personal Web Excel TutorialsAttention! In the formulas as a delimiter I use a semicolon (; )if you using my formula, then perhaps you need to use a comma (,)
Also for a decimal number I use a comma (,) you may need to use point (.) instead of

It works a dream but I would need the formula(s) to accommodate % values that appear more than once in the data. I know the sample data I had attached did not show this but this would be very important to appear in the top 10 pairing names.

I thought this might be the case. Please provide sample data that properly reflects the real data. If something is 'very important' and you don't include it, then we cannot provide a solution that takes it into account. You need to tell us everything that is important. Try again with the sample, please, showing how you want to deal with matching values, as it is an entirely different problem to solve.

My personal Web Excel TutorialsAttention! In the formulas as a delimiter I use a semicolon (; )if you using my formula, then perhaps you need to use a comma (,)
Also for a decimal number I use a comma (,) you may need to use point (.) instead of