Power Query Solution for merging data

Hi,

I have the attached spreadsheet.

The blue headers are first main piece of source data the orange headers are the second main piece of source data.

I normally extract the second source of data by using index/match using the DMA Referral ID as the primary key to populate the orange headers.

Thus combined the blue and orange headers become my data which I then perform calculations on in the subsequent fields of the table.

You can see all of the formulas contained in the table for the index/matches and the other formulas.

Is it possible to use Power Query to replace what I'm currently doing using my method?

If it's possible, would it be more efficient to use Power Query?

After playing around for a couple of hours, I am finding ways of integrating the formulas into Power Query, but I have reservations about spending alot of time on this.

If I were to use Power Query, how do I track down how a field is calculated? At the moment I click in a calculated cell and can easily see the formula that the contents are derived from. Once I use Power Query the formula is 'hidden' within Power Query and I can't quickly scan my data and trace the complicated logic that got me there.

Just like Power Pivot, which I'm also a novice at, I can't see how using Power Query is a better way to do what I'm already doing using formulas and standard pivot tables.