A pivot table is a summary of your data, packaged in a chart that lets you report on and explore trends based on your information. Pivot tables are particularly useful if you have long rows or columns that hold values you need to track the sums of and easily compare to one another.

When would you use a pivot table?

What is the use of a Pivot Table? A Pivot Table is used to summarise, sort, reorganise, group, count, total or average data stored in a table. It allows us to transform columns into rows and rows into columns. It allows grouping by any field (column), and using advanced calculations on them.

What is the benefit of pivot table in Excel?

Pivot Tables are worksheet tables that let you summarize and analyze your Excel data. Benefits include: Ability to recap using any data element and then drill down to review the details. Formulas may restrict sorting capabilities or may be corrupted when adding and deleting rows or columns.