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

I appreciate that but the dataset is loaded with confidential data; I’d likely lose my job if that were available to the public… With respect, I think that the screenshot adequately illustrates the format and layout of the data; the data itself should t really be necessary to see the problem (or my error).