One option if you want to avoid VBA is to use a pivot table
Won't be exactly as you required but may do the job

Count of ProducProduct
CustID.........Apples....Bananas........Kiwi.......Oranges
123.............1................................................1
345...................................................1
567.............1..............1.................................1

run a pivot wizard putting the CustID in the Row Field and
Product in both the Column Field and the Data
Also then remove Totals

Hope this gives you the idea.