This article describes how to go from this table which has empty rows & columns:
To this table in which the hidden columns are now shown:
A table with hidden rows and/or columns
- Select the table
- In the Object Inspector on the right, click either OUTPUT > UNHIDE ROWS AND COLUMNS > Unhide Categories Shown in Rows or OUTPUT > UNHIDE ROW AND COLUMNS > Unhide Categories Shown in Columns.
In this example, we will unhide hidden columns.
- Select from the list of columns you want to unhide.
In this example, we will unhide the $200,001 or more column but leave the Less than $15,000 column hidden.
- Click OK.
The results are as follows:
This tool cannot be used to unhide columns if the variable set selected in the Columns of the table:
Has the Structure of Text. Rows and columns of text data cannot be hidden.
Has the Structure of Date/Time. To choose which dates to include for data of this type, select the variable under Data Sets and then use Properties > GENERAL > Date/Time on the right.
Is a Banner. Data for banners is linked to the underlying questions. You will need to select the banner under Data Sets and then use Properties > DATA VALUES > Reset.