Counting the number of records per id

[rickaroo62]

I have a huge file with multiple rows per CustomerIDs and Dates.

There's a second field called PRODUCT which has various two digits text codes.

 

I want to accomplish two things

1) Convert the date to YYYY-MM

2) for all the combinations of CustomerID and YYYY-MM, I want to count the number of times each PRODUCT occurs.   

 

Attached is a sample of 6-7 customers.  

 

Thanks

 

Sample for Counting and SQL help.xlsx

[Funce]

Is the Spreadsheet an example of the SQL layout, or are you trying to update a spreadsheet?