I have a pivot table with some 8 columns. I always have the value for 8th column but the value for first 7 columns is optional. I am getting few blank values when I create a pivot table with these 8 columns. Can anyone help me avoid those blank values by skipping those columns and showing 8th column. I am attaching a sample file. Thanks in advance.
