在Excel中的数据透视表中删除一个空单元格 [英] delete an empty cell in pivot table in Excel

问题描述

我使用@xlm给我的答案减少Excel中的单元格数量< a>做下面的数据透视表。

I used the answer @xlm gave me on Reduce number of cells in Excel to make the below pivot table.

如何获得空白单元格的行消失？

How do I get the row with the blank cell to disappear?

以下是用于创建数据透视表：

Below is the dataset used to create the pivot table:

start,  end,    name,
830,    845,    ppa,
845,    900,    ppa,
900,    915,    Bob Hoskins liam Table,         
915,    930,    Bob Hoskins liam Table,        
930,    945,    Bob Hoskins liam Table,         
945,    1000,   Jack Door,          
1000,   1015,   Jack Door,          
1015,   1030,   Jack Door,          
1030,   1045,   Sara Car Tanya Coffee,      
1045,   1100,   Sara Car Tanya Coffee,      
1100,   1115,   Sara Car Tanya Coffee,      
1115,   1130,   Sara Car Tanya Coffee,      
1130,   1145,   Sara Car Tanya Coffee,      
1145,   1200,   Sara Car Tanya Coffee,      
1200,   1215,   Sara Car Tanya Coffee,      
1215,   1230,                  
1230,   1245,                  
1245,   1300,                  
1300,   1315,                  
1315,   1330,                  
1330,   1345,                  
1345,   1400,                  
1400,   1415,   Jack Whiskey,     
1415,   1430,   Jack Whiskey,     
1430,   1445,   Jack Whiskey,     
1445,   1500,   Jack Whiskey,     
1500,   1515,   Jack Whiskey,     
1515,   1530,                  

推荐答案

点击箭头并取消选择空白），然后点击数据透视表工具/选项/排序按日期排序。

Filter out blanks from Pupils column (Click on the arrow and unselect "blank") and then PivotTable Tools/Options/Sort to sort by date.

这篇关于在Excel中的数据透视表中删除一个空单元格的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！