Microsoft Office Tutorials and References
In Depth Information
Creating a Pivot Table
On the CD
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 operation? Often, you may have a two-way summary table, and it would be
convenient if the data were in the form of a normalized list.
In this figure, range A1:E13 contains a summary table with 48 data points. Notice that this
summary table is similar 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 create a pivot table from
this transformed table.
The companion CD-ROM contains a workbook, reverse pivot.xlsm , which has a macro that
will convert any two-way summary table into a three-column normalized table.
Creating a Pivot Table
In this section, I describe the basic steps required to create a pivot table, using the bank account
data. Creating a pivot table is an interactive process. It’s not at all uncommon to experiment with
Search JabSto ::

Custom Search