Load your CSV, choose the row field, an optional column field, the value field and an aggregation, then read the cross-tab and copy or download it as CSV.
It does the same cross-tabulation but with no setup, no file upload and no risk of the spreadsheet reformatting your data. Pick the fields from dropdowns and the table appears instantly, complete with row totals, column totals and a grand total.
Sum, count, average, minimum and maximum. Count works on any column including text, while the numeric aggregations skip cells that are not numbers so a few stray labels will not break the result or produce NaN.
Yes. Leave the column field set to none and you get a simple grouped summary — one line per distinct row value with its aggregate — which is often exactly the group-by report you were after.