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