cross tabulate

cross tabulate

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