How to Create a Cross-Tab (Two-Way Table) in Excel
A cross-tab turns a flat list into a grid — one field down the side, another across the top, a number in every cell. Building it by hand means a wall of COUNTIFS; a PivotTable needs refreshing. Here's the one-click way that writes a plain, shareable matrix.
Last updated: August 2026
| Region | Widget | Gadget | Total |
|---|---|---|---|
| East | 12 | 7 | 19 |
| West | 9 | 15 | 24 |
| Total | 21 | 22 | 43 |
Why the manual build is fiddly
To cross-tabulate Region × Product by hand you'd fill a grid with =COUNTIFS($A:$A,$F2,$B:$B,G$1) — one carefully anchored formula per intersection, plus total rows and columns. A PivotTable gets you the shape faster, but it lives in a cache you have to refresh, it resists plain editing, and pasting it as values to share is an extra dance. Neither is a quick, static answer.
The 1-click way — Tellsheet's Cross-Tab
Select your flat list and run Cross-Tab. Pick the field for the rows (down the side), the field for the columns (across the top), and how to summarize each cell — count, sum, average, min, or max (the last four use a value column you choose). It writes a two-dimensional matrix with a Grand Total row and column to a new sheet, as ordinary static values — nothing to refresh, and your source list is left untouched. Pairs with Group & Summarize and Unpivot.
Frequently asked questions
How is this different from a PivotTable?
Same two-way shape, but the result is plain static values on a new sheet — nothing to refresh, and easy to edit, sort, and share.
What can each cell show?
Count of rows, or sum, average, minimum, or maximum of a value column you pick.
Are there grand totals?
Yes — a total row along the bottom and a total column down the side.
Does it change my original data?
No. The matrix goes to a new sheet; your flat list stays exactly as it is.
Related Excel guides
Cross-tabulate a list in one click
Cross-Tab turns a flat list into a two-way matrix with grand totals, on a new sheet — as plain values you can edit and share.
Get Tellsheet free See pricing