+ Reply to Thread
Results 1 to 4 of 4

How to get rid of " (blank) " row or column in Pivot Table

  1. #1
    Registered User
    Join Date
    03-12-2014
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    53

    Question How to get rid of " (blank) " row or column in Pivot Table

    Hello,

    How to get rid of " (blank) " row or column which is generally added to the pivot table when some blank cells are present in reference data.

    I want to remove this " (blank) " row and column even if reference data have blank cells.

    Can this be done.

    Reason being the location of this " (blank) " cell in Pivot Table row and column changes when reference data is changed and Pivot Table is refreshed. Because of this, layout of the pivot table gets affected and so do the further dependent calculations.

    Seeking for help.


    Thanks in advance.

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: How to get rid of " (blank) " row or column in Pivot Table

    You can filter out the (blank) items. You can also use GETPIVOTDATA formulas so that the layout of the pivot table doesn't affect the downstream calculations anyway.
    Remember what the dormouse said
    Feed your head

  3. #3
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: How to get rid of " (blank) " row or column in Pivot Table

    Select a cell that shows the text "(blank)", hit the space key and hit enter. Now all blanks for this field are gone. Repeat for each field in the pivot table hierarchy.

  4. #4
    Registered User
    Join Date
    03-12-2014
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    53

    Re: How to get rid of " (blank) " row or column in Pivot Table

    Thanks for the solution..!!!

+ 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. Replies: 2
    Last Post: 06-06-2013, 12:45 PM
  2. VBA to filter "(Blank)" cells in pivot table , but in foreign languages too.
    By MarMo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-07-2013, 11:27 AM
  3. Pivot Table Field - Blank Cells without text "(blank)"
    By WRX in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-19-2013, 12:10 PM
  4. Replies: 1
    Last Post: 03-16-2011, 11:59 PM
  5. "BLANK" in column and row on a pivot table
    By Rmnticjas in forum Excel General
    Replies: 3
    Last Post: 01-23-2010, 12:05 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