Hello everyone. I'm new here. I've been scouring the threads for an answer to this and I apologize if it's already been explained.

My issue is that I have a very large data set where the same value may occur in multiple columns. I need to create a pivot chart, or possibly find another solution, that allows me to track the number of times the value occurs within a date range.

Something like this but I need it to tell me total # of each fruit purchased for that month.

Shopper date product 1 product 2 product 3
jim 1/31/2013 apple banana orange
jill 2/13/2013 banana orange apple
bob 2/4/2013 apple orange banana
jill 1/31/2013 apple banana null
joe 2/13/2013 orange apple banana
betty 2/4/2013 banana orange apple
claire 1/31/2013 apple null null
bob 2/13/2013 banana null null


Here is the example data file.

Thank you in advance. Any assistance is appreciated.
pivot grouping example.xlsx