Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.