Say you have data like this:

 

 

 

Is there a way to display this data as:

 

 

Perhaps with a Pivot Table?  (I don't really have a good understanding of them yet).

 

I suppose the alternative would be to have numeric fields Apples, Bananas, Oranges, but that seems very inefficient profiferation of fields, particularly if there are many fruit types!  It would seem more efficient to be able to use the values in a FruitType field as column headers.