How to Unhide Rows and Columns

This article describes how to go from a table which has hidden rows or columns, such as "Less than $15,000" and "$200,001 or more" in this example:

To a table in which the hidden rows or columns are now shown:

Requirements

A table with hidden rows and/or columns.

Select the table.
In the object inspector, click either Inputs > UNHIDE ROWS AND COLUMNS > Unhide Categories Shown in Rows or Inputs > 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:

Note that this method will reset all rows/columns, rather than being able to select specific ones to unhide.

Technical details

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 in the object inspector.
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.