Use this table transformation to reorganize records by chosen row keys, column keys, and aggregate values for inspection or downstream analysis.

CSV

CSV text with a header row to pivot.

Delimiter

Single-character field delimiter.

Group columns

Columns whose distinct values form the groups.

Aggregation

Aggregation applied to the value column per group.

Value column

Numeric column to aggregate; optional when counting rows.

Aggregate CSV rows into a deterministic grouped pivot table. The tool evaluates the supplied inputs together and returns the named outputs below; it does not infer omitted operating conditions or change the units shown.^[1]

Pivot table

Pivot table with sorted group keys and one aggregated column.

• CSV does not carry a universal type system, schema, delimiter, locale, or missing-value convention. A pivot can silently combine records if identifiers, numeric parsing, duplicate handling, or aggregation rules are chosen incorrectly.
• Use finite inputs in the displayed units and preserve more precision than the final presentation requires. Independently verify safety-critical, financial, compliance, or production decisions.

Inspect parsed columns and duplicate keys before pivoting, state the aggregation function, and retain the unpivoted source. Validate totals before exporting the transformed table.

• CSV to Markdown Table Converter

  Convert RFC 4180 CSV text to a Markdown table.

• CSV to Table

  Parse CSV text into the canonical portable Tool.io table representation.

• List Unzip Tool

  Split table rows into named columns, the inverse of zipping lists.