Adding empty columns to column labels

[richjo100]

Hi

Thanks for your help in my last question. Now another one Im afraid. I have a list of timesheets and some users have missed day.

The source data is

Name	Date	Hrs
Richard	1 Aug 2015	5
Richard	2 Aug 2015	2
Sam	1 Aug 2015	2
Sam	2 Aug 2015	5
Sam	3 Aug 2015	11

Now in the tale above I have the column labels being the second column (date) and the row labels with the username. The actually data I the hours which is summed up.

My problem is that Sam has worked 3 days correctly
Richard has only logged against 1 and 2 August and has nothing against 3 August. When I filter on Richard I cannot easily see that this is missed. It just doesnt show anything for the 3 August. Whereas really I want this shown in the column labels but with it being empty.

Can I do this so that the column labels start with the earliest date in column2 and end with the latest date?

Thanks

[FDibbins]

It's not showing anything for Richard for that day, because there is nothing to show for Richard for that day - excel wont/cant show what isnt there

I would se this up this way...

	A	B	C	D
1		Richard	Sam	Bob
2	1-Aug	5	2	5
3	2-Aug	2	5	10
4	3-Aug	0	11	15

That way, you would just enter 0 where the person did not work

[richjo100]

Thanks - that does make sense actually. I have worked around it by doing a different type of pivot.

Thanks