Pivot a CSV
Pivot a CSV: one column's distinct values become row labels, another's become column headers, and a third is aggregated into each cell by count, sum, mean, min, or max. Runs entirely on your device.
Pivot a CSV reshapes long data into a cross-tab. The column named in rows supplies the row labels; the one named in columns supplies the headers. A third column, named in values, feeds each cell through whichever statistic you pick: sum, mean, min, max or count. Anything but count needs values set. Sum, mean, min and max quietly skip non-numeric cells.
Questions
What do rows, columns and values control?
rows picks the column whose values become row labels, columns picks the one whose values become column headers, and values picks the column that gets aggregated into each cell.
When is values required?
Whenever agg is anything other than count; count works without a values column since it counts rows.
What aggregations are available?
Count, sum, mean, min and max, chosen with the aggregate option and applied to the value column you name.
What happens to non-numeric cells under sum or mean?
They are silently dropped from the calculation, so a bucket with only non-numeric values in that column comes back blank.
What if rows or columns does not exist in the file?
It is refused, naming the missing column and listing the file's real headers.
What does the output include?
Both a downloadable pivoted CSV and a summary line stating the row and data-row counts, plus how many row and column labels resulted.