A cross table is a common type of table featuring a matrix of values between two orthogonal lists of header data. To turn a cross table into a straight table, use a crosstable prefix.
The syntax is:
crosstable (attribute field , data field ,Qualifier)
The crosstable wizard is dialog driven method of creating the crosstable syntax. This dialog is opened by clicking the Crosstable button in the Options page of the File Wizard. The crosstable wizard holds the following options:
The number of qualifier fields that precede the fields to be transformed.
The name of the new field that will contain all the fields (attribute values) to be transformed.
The name of the new field that will contain the data of the attribute values.