Help creating table for creating correct data layout for Power Pivot - Am I missing something?!

I'm relatively new to PowerPivot and Pivot Tables so I'm sure I'm making some rookie error here but can't find an uncomplicated or clumsy way of doing this...   I have a set of Data. It includes th...