Excellent Peter! What guidelines can you give me on how to do this? I would like to learn how to do this with Power Query. Is there some tutorial or reading that you can suggest please?
Please see attached file. I am trying to compare different sites (site 1, site 2, etc) against each other in terms of the CPC (e.g. E17 compared and ranked against H17, K17, O17, Q17 and T17). I am looking for a more elegant solution that the current formula used.