I have a number of employees that had multiple check-in times. So for example Peter may have checked in 3 times on Jan 1, 2 times Jan 2, 7 times Jan 3 etc. These dates are in the Date column.
I want to create a pivot table which shows an employee and the number of checkins per day. So I'd want...