On import from data file, if the Crosstab checkbox was selected on choosing a source, clicking the Next button opens the next wizard page:
The wizard will identify the start data point by using the data downloaded from the file. Data block, row and column headers are highlighted with different colors. If required, it is possible to correct data area by changing data area borders and heading/sidehead borders.
On clicking the Next button the next wizard page opens, on which the range of imported data can be corrected.
The range is corrected by deleting the row and columns with irrelevant data. To delete column or row, select the Exclude item in the tab header area:
NOTE. Only right-most or left-most columns of the heading and sidehead are allowed to be deleted. The headers should contain at least one column and one row.
Clicking the Next button opens the page where it is available to correct data, which will be automatically recognized and downloaded from the crosstab.
See also:
