Got stuck with making timesheet, multiple days, job numbers, hours

[Scarabeus79]

Hello Excel Gurus, I have been redoing my companies time sheet to make it easier to fill in but I got stuck at this.
The left and right sections represent two different sheets. What I'm trying to do is: If Tuesday's job number is the same as Monday's put the hours in the same row. If not put it in the second row. So if job numbers are the same on different days put the hours in the same row. I got half way through but the hours will show up for the day it belongs to and also in the row where it should go based on the job number. I've spent a looong time, i'm pulling my hair out. Any solutions in mind? Example below of what I'm trying to achieve.

Mon	Tue	Wed	Thu	Fri	Sat	Sun				Job No.	Hours
8	6				7				Mon	99	8
									Tue	99	6
		2							Wed	88	2
			3	11					Thu	77	3
									Fri	77	11
									Sat	99	7
						12			Sun	66	12

<tbody>
</tbody>