Note: To understand this example, it is recommended to read Example of Pivoting first.
Apart from changing format from tall/skinny to short/wide, pivoting can be used to create a more compact table. Consider the following table, based on a series of temperature measurements:
|
City |
Month |
Day |
Temp |
|
London |
February |
1 |
5 |
|
London |
February |
15 |
8 |
|
London |
May |
1 |
15 |
|
London |
May |
15 |
22 |
|
New York |
February |
1 |
9 |
|
New York |
February |
15 |
7 |
|
New York |
May |
1 |
18 |
|
New York |
May |
15 |
24 |
Tall/Skinny=>Short/Wide conversion lets us pivot and aggregate this table, producing the following:
|
City |
avg(Temp) for February |
avg(Temp) for May |
|
London |
6.5 |
18.5 |
|
New York |
8 |
21 |
A smaller table has been created, summarizing the original table. The following settings were made in the Pivot Conditioning dialog to produce this result:
Identity: City
Category: Month
Values: Temp
See also: