All tools
Pivot Table Generator
Group spreadsheet rows and calculate sums, averages, or counts.
Spreadsheet previews and results will appear here
Input and result notes
Grouping supports count, sum or average; sum and average skip nonnumeric values. Keys group by text representation, and output is data rather than an interactive Excel pivot table.