[Google Spreadsheet] How to create pivot table?

Raw data

Data => Create pivot table

Configuration:
* Set Fruit as row
* Create multiple values, including summary, average and median.

Check Result