Returning Intersecting Values

[d_parker]

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

Date	Customer1	Customer2	Customer3
9/1/14	1
9/2/14		.5	.5
9/3/14	.75	.25

<tbody>
</tbody>

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

	A	B	C	D	E
1	Date	Customer	% Day Worked	Customer	% Day worked
2	9/1/14	Customer1	1
3	9/2/14	Customer2	.5	Customer3	.5
4	9/3/14	Customer1	.75	Customer2	.25

<tbody>
</tbody>

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.