To analyze and summarize data. A common example is summarizing the details from database records and placing them into a spreadsheet. The following example places the details of order records into summary form.
Transactions Being Cross Tabbed
Date Customer Quantity
1- 7-98 Smith 7
1-13-98 Jones 12
2- 5-98 Gonzales 4
2-11-98 Fetzer 6
3-10-98 Smith 12
3-22-98 Gonzales 15
Results of Cross Tab
Customer Jan Feb Mar Total
Smith 7 12 19
Jones 12 12
Gonzales 4 15 19
Fetzer 6 6
Total 19 10 27 56