Excel
Using PivotTable and PivotChart Report
By making this table, it helps you to view and sort your data easily. We can use PivotTable to make different kind of summary.
Here is a data that 2 shops are selling apples and oranges in 2001 and 2002.
1)Data> PivotTable and PivotChart Report
2)Click next
)3)It will choose your data automatically
4)Click layout
5)Drag and drop the data that you would like to see
6)Click ok and finish
