Part IV: Managing and Analyzing Data
Using Worksheet Outlines.” Although the range contains descriptive information about
each value, it does not consist of normalized data. In fact, this range actually resembles a
PivotTable summary, but it’s much less flexible.
FIGURE 29.4
This range is not appropriate for a PivotTable.
Figure 29.5 shows the same data but normalized. This range contains 78 rows of data—one
for each of the six monthly sales values for the 13 states. Notice that each row contains
category information for the sales value. This table is an ideal candidate for a PivotTable,
and it contains all the information necessary to summarize the information by region or
quarter.
Figure 29.6 shows a PivotTable created from the normalized data. As you can see, it’s simi-
lar to the nonnormalized data shown in Figure 29.4. Working with normalized data provides
ultimate flexibility in designing reports.
