What is a pivot table?

Answer 1

A pivot table summarizes data from its source table. For example, if you had your annual expenses in a spreadsheet, a pivot table could produce total expenditures by category. Such as total amount spent on food, utilities, medical, etc.