Microsoft Office Tutorials and References
In Depth Information
Figure 18-6: A pivot table created from normalized data.
A reverse pivot table
Excel's pivot table feature creates a summary table from a list. But what if you want to perform the opposite oper-
ation? Often, you may have a two-way summary table, and it would be convenient if the data were in the form of a
In this figure, range A1:E13 contains a summary table with 48 data points. Notice that this summary table is simil-
ar to a pivot table. Column G:I shows part of a 48-row table that was derived from the summary table. In other
words, every value in the original summary table gets converted to a row, which also contains the region name
and month. This type of table is useful because it can be sorted and manipulated in other ways. And, you can cre-
ate a pivot table from this transformed table.