Flat one line per customer

I have an Excel spreadsheet that displays Customer and Product Info like this example:

CustID...Product
123.......Apples
123.......Oranges
345.......Kiwi
567.......Oranges
567.......Bananas
567.......Apples

Is there a way in Excel to have the data appear so that each CustID only appears in one row with the product listed in the adjacent columns like this:

CustID..Prod1.......Prod2..........Prod3
123.......Apples......Oranges
345.......Kiwi
567.......Oranges....Bananas.....Apples


Let me know if you have any ideas on how to do this. Thanks

You have to use macro for that

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.