A pivot table is a useful tool in data analysis that can give you an overview of your data. We'll show you how to create one in Excel and Google Sheets.

Excel has a facility to consolidate ranges in a pivot table but this is for a very specific scenario and I, personally, have yet to find a practical use for this. It certainly does not help us here.

Now select the 'Insert' tab and then 'Pivot Table'. It is best to insert the table into a new document. On other programs like OpenOffice data or in a Google spreadsheet, you might have to click the ...

Pivot tables in Google Sheets summarize smaller sets of data from a more extensive dataset and can be sorted by rows, columns, values, and filters.