+ Reply to Thread
Results 1 to 2 of 2

Cell repeats value above if no data.

  1. #1
    Forum Contributor
    Join Date
    03-03-2011
    Location
    Ottawa, Ontario
    MS-Off Ver
    365
    Posts
    136

    Cell repeats value above if no data.

    I have a pivot table based on a data model from a Power Query that has started to act strange. I have a name field in the model that isn't filled in until the date is past so it can remain blank on the pivot table. Now my pivot table is filling in every cell that should be blank with whatever name is on the cell above it. I am not sure how this happened or what I am missing but any help would be greatly appreciated. Below is a little example of what it looks like now and what should be blank.

    ID Date Name
    12 06/01 Bob
    13 06/02 Dave
    14 06/05 Tom
    15 06/16 Tom (SHOULD BE BLANK)
    16 06/17 Tom (SHOULD BE BLANK)
    17 06/18 Tom (SHOULD BE BLANK)

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Cell repeats value above if no data.

    I think starting with Excel 2010, there is an option under PivotTabel Tools -> Design -> Report Layout to Repeat All Item Labels. There is also an item there not to repeat the labels.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Pulling individual data in pivot table when data repeats. Need Calculated Field
    By ChemistB in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-11-2017, 02:12 PM
  2. [SOLVED] Add Quantities if Data Repeats
    By Ocean Zhang in forum Excel General
    Replies: 5
    Last Post: 07-15-2014, 10:28 AM
  3. Copying data without repeats
    By 03staylo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-11-2014, 02:31 AM
  4. Replies: 6
    Last Post: 12-09-2012, 09:00 PM
  5. Formulae for: 4 most repeats,4 least repeats in a series of numbers
    By Sedge in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-02-2010, 04:56 AM
  6. Replies: 3
    Last Post: 07-04-2008, 07:42 PM
  7. Repeats of data
    By rdubya in forum Excel General
    Replies: 1
    Last Post: 09-16-2007, 10:02 PM

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