Returning non-blank cell column/row headers to new array

[jjkellog]

I have a set of changing data that I need a formula to help with. There are column (month) and row (person) headers with data (like sales), and I would like to return all of the non-blank cells with both headers and the value.

This is a pic of the sample data, with some blank cells thrown in the mix.
Screen shot 2013-08-16 at 11.18.17 AM.png

And this is what I'm attempting to get as the output.
Screen shot 2013-08-16 at 11.18.01 AM.png


I've attached a small demo sheet with the sample data, as well as what I'm aiming to get it to look like when the formula is applied. I've been playing with some of the non-blank things, but can't quite seem to get what i want out of it. Any suggestions?

Thanks!
Josh

Sample.xlsx

[RobertMika]

Sample(1).xlsx
A small challenge but please see attached.

[jjkellog]

Thank you Robert!!! That works beautifully. I was hoping, since I'm not an Excel guru, if you could help explain a few parts (in case I need to change the size or orientation of the input array). I've tried migrating the formulas you provided into a more complex, real-life scenario sheet (attached here) yet I couldn't get the same consistency out the answers... maybe I'm copying something wrong? Or do the formulas need to be tweaked depending on the placement of the array? (The matrix in question in my attached file is colored red, starting at B55, and the three columns below the matrix are my output areas).

Thanks again!
block1.xlsx