Pivot table with filtered columns getting extra unknown column

[andreicatalin]

Hi there,

I am trying to put together a pivot that shows data (both nulls and values) per a few categories (delete headers below) across a few months.

In some months there is data - in some, there isn't. I want to be able to show both.

The pivot returns this odd column - highlighted with 0s and null values. Any Insight as to how to get rid of it & have a clean table showing months with 0 and months with values? 

[NhanNguyen]

So you want to convert 0 to Nulls or?

[andreicatalin]

Thanks for getting back. 

I want to essentially remove the column with a null header. 

I have column titles all across (although I obscured them in the screenshot). I essentially want the following:

             Column1         Column 2     Column 3

Jan      0                         0                       0

Feb     0                          0                       0

Mar      0                         0                       0

Apr     0                          0                       0

May    58.1                  1.3                    0.3

etc.