I have pivot table column that has null values in some instances from top to bottom. To get rid the nuisance how can I hide this automatically? Do I need to use vba? Your help would be much appreciated.
You should be able to remove that column from those that are displayed. If the columns only sometimes have null values, I don't know of a way to programmaticall y remove a column that is all nulls and then restore it when it has values.
Comment