Excel 2008 : Rank Array Values and return with Column Headers and Row Headers

Hello!

I am looking to rank the values in an array with the column headers and row headers returned with each value.

5k 10k 15k
Matt 4 5 9
Brian 6 7 8
Phillip 2 4 5

OUTPUT:

Phillip 5k 2
Matt 5k 4
Phillip 10k 4
Matt 10k 5
Phillip 15k 5
Brian 5k 6
Brian 10k 7
Brian 15k 8
Matt 15k 9

Thank you in advance! My array is much bigger so this will save me A LOT of time.

This is excellent, THANK YOU! I am still letting it sink in, I may have some follow up - Thank you, Tigeravatar!