Remove null columns from pivot table

[Flytoohigh]

Excel 2010 - I have created a pivot table with YoY Count as a column. The first year has no YoY data since there is no prior year for comparison. This is resulting in YoY Count field with data for for all subsequent years except that first year. Because the pivot table will be pivoted I cannot simply hide the column. Is there a way to remove the column with no values without hiding it?


[TABLE="width: 407"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]LY[/TD]
[TD][/TD]
[TD]TY[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Region[/TD]
[TD]Month[/TD]
[TD]Count[/TD]
[TD]YoY Count[/TD]
[TD]Count[/TD]
[TD]YoY Count[/TD]
[/TR]
[TR]
[TD]Domestic[/TD]
[TD][/TD]
[TD]1,431,470[/TD]
[TD][/TD]
[TD]1,494,963[/TD]
[TD]63,493[/TD]
[/TR]
[TR]
[TD]MCLA[/TD]
[TD][/TD]
[TD]607,880[/TD]
[TD][/TD]
[TD]691,262[/TD]
[TD]83,382[/TD]
[/TR]
[TR]
[TD]Pacific[/TD]
[TD][/TD]
[TD]146,906[/TD]
[TD][/TD]
[TD]97,173[/TD]
[TD](49,733)[/TD]
[/TR]
[TR]
[TD]TransAtlantic[/TD]
[TD][/TD]
[TD]224,393[/TD]
[TD][/TD]
[TD]240,224[/TD]
[TD]15,831[/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD][/TD]
[TD]2,410,649[/TD]
[TD][/TD]
[TD]2,523,622[/TD]
[TD]112,973
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Trevor G]

Look at this link it may help: https://www.extendoffice.com/documents/excel/3685-excel-delete-empty-columns-with-header.html