Returning Intersecting Values

[d_parker]

We are keeping a time sheet for our employees in the following format

[TABLE="width: 500, align: left"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Customer1[/TD]
[TD]Customer2[/TD]
[TD]Customer3[/TD]
[/TR]
[TR]
[TD]9/1/14[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9/2/14
[/TD]
[TD][/TD]
[TD].5[/TD]
[TD].5[/TD]
[/TR]
[TR]
[TD]9/3/14[/TD]
[TD].75[/TD]
[TD].25[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]








Even though it's a breeze for employees to track their time, the business office finds this format hard to read - I'd like to create a second sheet pulling data from the first that auto-fills in the following format

[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Date[/TD]
[TD]Customer[/TD]
[TD]% Day Worked[/TD]
[TD]Customer[/TD]
[TD]% Day worked[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]9/1/14[/TD]
[TD]Customer1[/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]9/2/14[/TD]
[TD]Customer2[/TD]
[TD].5[/TD]
[TD]Customer3[/TD]
[TD].5[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]9/3/14[/TD]
[TD]Customer1[/TD]
[TD] .75[/TD]
[TD]Customer2[/TD]
[TD].25[/TD]
[/TR]
</tbody>[/TABLE]

I'm having difficulty with all the statements to avoid printing empty cells but still pulling populated intersecting data into B2:E4

 

[Comfy]

May I suggest something different?

Ask you employees to complete the timesheet but use the following format.

Date ¦ Customer ¦ Time

Excel 2010
	A	B	C
1	Date	Customer	Time
2	01/09/2014	Customer1	1
3	02/09/2014	Customer2	0.5
4	02/09/2014	Customer3	0.5
5	03/09/2014	Customer1	0.75
6	03/09/2014	Customer2	0.25
Sheet1

This would make formatting and reporting on the data very easy.

 

[d_parker]

That would be very easy - but no offense, there are reasons i asked for, what i asked for.