Your idea of "averaging the tow ranks" sounds like a score to evaluate the providers.
An average of two ranks gives a score, but eliminates information of individual ranks.
Which is better depends on your purpose of analysis.
It just comes to that, scatter might be viz alternative.
I played a little with your data.
This might look hazy at the first sight, but if your select and highlight from the color legend and shape legend, it's easy to see the rank position.
v81 ranking_v2018.1_v2018.1.twbx 191.3 KB
Thank you for your Time.
Yes,Scatter Plot is good alternative Viz .
Although i have more than 40 Measures and 400 Providers.