Why would you use a pivot table?

Answer 1

A Pivot table is an interactive way to quickly summarize large amounts of data within MS Excel.  The Pivot table can analyze numerical data in detail, and answer unanticipated questions about your data. You need to create the criteria in terms of fields you want to analyze and with the Pivot Table wizard MS Excel makes it easy for to create one.

Answer 2

A pivot table is needed when you have a large set of data that has become very tedious to find information in. With this table, you can extract only pertinent information to be displayed as a report and even a chart.