sorting data

[jbrown021286]

i am wanting to take the raw data shown in the image on the left and have a key data point sorted in the sheet shown in the image on the right. as you can see in the image on the left there are employee daily performance numbers sorted by person in column a then broken down by date in column till it gets to the next employee. i can change the names in the image on the right to exactly match the names on the image on the left if needed but i am looking for column d "Sold Hours" to be sorted in the corresponding row with the name and corresponding column with the date.

 

[Cancyy]

Maybe Pivot could help