Data import interfaces in the web application and desktop application match.
If, on import from data file, the Crosstab checkbox was selected, 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, one can 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 rows and columns with irrelevant data. To delete column or row, select the Exclude item in the table header area:
NOTE. Only rightmost rows in sidehead or leftmost columns in heading are allowed to be deleted. The headers should contain at least one column and one row. Deleted rows and columns will not be used and will be unavailable.
Clicking the Next button opens the page where one can correct data, which will be automatically recognized and downloaded from the crosstab.
See also:
