UPCOMING WEBINAR: Finding the story in your survey data This article describes how to go from a table with entire rows and/or columns of 0% or missing data...
..to a table where these empty rows and columns are removed:
Requirements
A table.
Method
1. Select your table.
2. Go to Data > Rules in the object inspector.
3. To apply the rule, select Plus (+) > Modify Whole Table or Plot > Hide empty rows and columns > OK.
A note is added to the footer when any rows or columns have been removed.