I am getting a huge Excel file through a report from a database software (where,unfortunately dont have access to query designing). It just produces Excel file . It has students name and number of items of experiment he is doing every day. Although there are fixed number of items not all students do all items. some students may do few every day and different items on different days.

I wanted to know how many times every student is doing each item. I have tried with crosstab but it did not give me desired results because, the number of rows per day per student is not fixed. some student do many items whereas some do only few so.

The following picture illustrate a sample output from the database (left) and what I am trying to make(right): excel.png
Could someone direct me will I be able to do this in Excel or any other workaround like exporting to MS Access etc?

Thanks