One other thing you can do it to use PIVOTs in excel. You would still need to modify the data though (use macros or FIND and REPLACE).
[1] remove the time from the date values.
[2] rename the event to sort it out. (ex. Out of Bed = 1 Our of Bed, etc.)
[4] Use the pivot tool and the wizard will guide you through.
