Daverage function with rows instead of colums.
 

I need to calculate a weekly moving average of prices by leverage from
information from a another sheet. An example of the sheet is below:

Deal Co. A Co.B Co.C
Week 1 1 3
Leverage Pricing
5.0x - 200 300
4.5x 250 125 400
4.0x 350 - 500

I need to create a table on another sheet that will calc. the weekly average
price of each Leverage level. The new table looks like this:

Leverage Average Price (wk1) Avg Price (wk2)
5.0x
4.5x
4.0x

Can anyone help? Thank you