I work with a huge amount of data in Pivot Tables, and I constantly come across the issue attached. Basically, I pivot transactions to show totals and filter out the different stores. Some item descriptions, though, are the same for different UPCs and as a result, Excel places a blank into the cell that should also say "12 oz cheesesteak". The way the pivot is organized cannot be changed. Is there a way that can automatically make that cell (and hundreds of others in my actual files) say what it is supposed to say?
If anyone is wondering, I live in Philadelphia, haha.
Bookmarks