I have a Pivot table that I am trying to combine the side item totals into one total. Right now one side item goes from 07 to 93 (called Code) and the other side item goes from 07A1 to 93A4 (called Altcode). I would like all the 07A1 (etc) together and if it is blank for it to go under 07...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.