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