Sometimes you may have entire rows or columns in your table that are missing or 0. This could be due to filtering or because a survey question was only asked in particular waves. In these cases, you may want to tidy your table and hide these empty rows and columns. This article describes how to go from a built-in drag and drop 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.