Pivot Table Generator

What This Builds - and What It Does Not

This tool produces the result of a pivot: a summary grid of numbers you can read on screen and download as a workbook. It does not write a PivotTable object into the file. There is no field list to drag, no slicer, no expand-and-collapse, and nothing to refresh when the underlying data changes - the grid is a snapshot. That is the right trade when you want a grouped answer in a few seconds without opening Excel, and the wrong one when you need an interactive report to hand on.

The Three Fields

Rows is the column whose distinct values become the left-hand headings. Values is the column being summarized. Columns is optional: leave it on No column field and you get a simple two-column list headed with your row field and, for example, sum of Amount. Choose a column field and the distinct values of that column spread across the top, with a Total column added on the right. Row and column headings appear in the order they were first met in the sheet - not alphabetically, not by size.

With Rows = Region, Columns = Quarter, Values = Amount, Sum:

How the Aggregations Behave

Count counts the non-blank cells in the value field for that group, whatever they contain - use it to count orders per region without caring about amounts. Sum and Average only see cells that parse as numbers; currency symbols, thousands separators, percent signs, and spaces are stripped first, so $1,200 counts as 1200, while N/A is skipped rather than treated as zero. A group with no numeric cells shows 0. An empty intersection of a row and column key also shows 0, not a blank - the East/Q2 cell above is a real zero, not missing data.

Edge Cases

Row and column labels are matched exactly after trimming, so West and west stay separate groups - run Excel Data Cleaner with Title Case first if your categories are inconsistently typed. Dates used as a row field group by their underlying Excel serial number, meaning one group per day; add a Month or Quarter text column to the source data instead. There is no grand-total row along the bottom. Untick First row headers for a sheet with no header row and the fields become Column 1, Column 2 and so on. The preview shows the first 30 rows of the result; the download contains all of them.

When a Different Tool Fits Better

To see the same grouping as a picture, the Excel Chart Maker runs the identical aggregation and draws it. If your data is already a crosstab and you need it flattened back into a list before analysis, Unpivot Excel is the reverse operation. When the summary has to stay live inside a workbook, a formula beats a snapshot: the SUMIFS generator writes the multi-criteria total, and the SUBTOTAL generator writes one that follows a filter. And when you want every underlying row per group rather than a single number, use Split Excel by Column Value.