How to create a Pivot Table from downladed data

[excel?]

I have data downloaded into an Excel worksheet and need to pull into a pivot table. I cannot figure out how to pull into a pivot table due to the layout of the data.

Any Ideas on how to get this into a Pivot Table?

Here is an example of what the data looks like:

A B C D E F G
1 [ 09/19/2016 ] [ 09/20/2016 ]
2 ID # Name Unit Hours Dollars Hours Dollars
3 100 John 107 9.83 $196.60 8.80 $176.00
4 110 Nancy 234 9.93 $198.60 8.15 $163.00
5 120 Steve 748 8.95 $179.00 8.23 $164.60
6 130 Lisa 448 8.82 $176.40 7.23 $144.60

** The each Date is merged across 2 columns.

I am wanting to have a Pivot Table that allows me to move the Fields around and get Totals/Sub-totals depending on what I am trying to look at, but I cannot figure out how to have the Table recognize the Dates as a usable field and the Hours and Dollar to be a Single Field. It tries to label them as Hours, Hours1, Hours2 etc..

Thank you