+ Reply to Thread
Results 1 to 1 of 1

Fill Blank Cells Automatically in Pivot Tables

  1. #1
    Registered User
    Join Date
    04-11-2012
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    1

    Fill Blank Cells Automatically in Pivot Tables

    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.
    Attached Images Attached Images

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1