Reshape

Create pivot table summaries from long CSV data

Summarise long-format CSV data into pivot tables grouped by row and column keys.

🛡️ Your rows never leave your browser.
Why Onfyt: Handles string-valued category columns with 50+ unique values as pivot column headers without crashing—tested up to 200 distinct product categories.

Interactive Sample Data

regionproductrevenue
NairobiSolar Panel4500
MombasaInverter3200
NairobiInverter2800

How this tool works

A pivot table answers the question: across each combination of two categorical variables, what does the number look like? Starting from one row per transaction—region, product, amount—the pivot groups every region into its own row, turns each distinct product into a column header, and sums the amounts at each intersection cell. The resulting wide table is ready to paste into an executive slide deck or drop into a BI dashboard without a formula in sight. DataFix's pivot tool lets you select any column as the row grouper, any column as the column grouper, and any numeric column as the value, with a choice of aggregation function. The resulting wide table is ready for charting in Excel or import into a BI dashboard. Pivoting reshapes long transactional event logs into structured cross-tabulation summaries. Grouping by entity and aggregating metrics across categorical dimensions provides immediate executive visibility into sales distributions, quarterly trends, and inventory counts. Transforming transactional records into structured cross-tabulation summaries reveals quarterly revenue patterns, regional distribution metrics, and cohort volumes. Transforming transaction logs into cross-tabulated views eliminates manual formula maintenance in monthly reporting.

Things that usually go wrong

  • Duplicate key+pivot combinations produce multiple values for one cell — aggregation (sum, first) must be specified.
  • Many unique pivot values produce very wide output.

Edge cases we tested

🧪 Multiple rows for same row+column combination

Aggregated using the selected function (sum by default); count also available.

🧪 Column header value containing a comma

Header value is quoted in the output CSV.

🧪 Column group with 100+ unique values

Creates 100+ output columns; user warned that wide tables may be unwieldy.

Frequently Asked Questions

What is a pivot?

A pivot transforms a long-format table (one row per observation) into a wide-format table (one row per entity, one column per attribute).

How do I handle duplicate values?

Include the aggregation in your instruction — e.g. "Pivot by region and product, summing sales" or "count by category". Supported operations: sum, average, first, last, count, and concatenate.

Related tools

Reshape

Transpose CSV

Flip a CSV matrix by turning rows into columns and columns into rows.

Open Tool →
Reshape

Group By and Count

Aggregate CSV rows by one or more group-by columns with count, sum, mean, min, or max.

Open Tool →
Reshape

Filter CSV Rows by Condition

Keep or discard CSV rows based on flexible conditions applied to any column.

Open Tool →