Real Excel Skills - 304 - Removing blank Rows in Pivot Tables 

That worked !!! I was stressed out to remove this. You saved me lot of time. Thanks

I have been searching for solution to this for months. You just saved me mate. 👍👍👍👍👍👍👍👍

Just go straight to the point in your future videos. If a video is about removing blank rows, most of us come here because that's the only thing they needed. The rest of the stuff, you can create separate videos and potentially get more views than you have from this one.

This was EXACTLY what I was looking for but could not find a solution! Thank you for putting the time stamp to get to the problem & answer. I would also suggest that you realign the dual screen. Thank you!!!

Searched too much for real solution but not found it, You are the Only one have the solution so thanks a lot and appreciate your efforts....

You have no ideaaa how much thiss helpss meeee goshh 😭, i was so stressed out bcs of that one blank and finally i came across this video. I'm not the type who likes to write comments on yt but i just want to appreciate ur work. Thank you so much, hope u have an amazing life ahead ✨

You solved my problem!!! Been trying to eliminate that (blank) in my dashboard. I rarely leave comments, but you helped me a lot. Thanks a lot!

Resize tables, Hide blank data, check for cardinality if there... thnx for this also❤❤❤

These are the tricks that I've been looking for in my project

When "add this data to data model" is checked, this filter doesnot work. Please suggest for that.

Brief & effective video. Thanks! It works on Pivot columns if data is text its not working if the data is date, as it doesn't show Label filters instead it shows Date filters.

Thank you so much for this. Simple solution that helps a tonne!

god tier excel advice

I know this is old, but I'm just finding it, because I'm just dealing with this problem. But, I also have another problem that's the same but different, if you're still checking responses to this video. This fixed my one pivot table. Thank you so much! But, I have another pivot table where the filter is a nothing for empty row labels. The column is brand names. Some of the data is for fees, which have no brand name associated, so that column is empty. (blank) doesn't show up in the filter list. It's just a checkbox next to nothing. I've tried filtering (blank). I've tried filtering "". I've tried filtering 0. I've tried filtering "0". I've tried filtering a space. I've tried filtering " ". I can uncheck it, obviously. And, I have been. But, I'd like to apply this trick you used here, to automate as much as possible, and minimize my number of steps. But, I cannot figure it out. I can filter anything above 0, and that works. But, I'm worried one day the data will throw me a curve, and that will filter out something I didn't know was there. I'd like to be able to filter out labels that are specifically "nothing".

Sir you helped sort my real time problem..thanks a ton !

10 mns talking 1 mn action you stress me up

Great video mate, explained perfectly.

Excellent Teacher❤

Thank you so much...

Thanks for this knowledge sharing..it help me real time

It worked! but what do you need to do when there's a empty row in your pivottable with a value 0.00?

Perfect solution, thank you!

Is it just me or is the easiest way to see if cells are equal is just =A1=A2351. I don't think you need the '--' in there. What's the benefit for 1/0 vs. True/False?

You are a genius!! problem solve

Problem solved! thank you

Thank you so much ❤ you solved big problem for me now 😅

Thanks buddy❤

My Label Filter cannot be click, may I know why

This is absolutely great! Like!

life saver

Question, when using a slicer on the pivot table, it does not hold the label filter when selecting on the slicer and then cancel the filter on the slicer, is there a way to make it permanent?

Good one

Can you replace (Blank) in the Column field with "-"

Legend!

Awesome explanation and good tips. Much thanks.

Why not simply ensure the data source only includes data and no blank sections below. Data updates adding extra rows after - would the pivot table pickup extra rows?

Thanks for this amazing solution.Can we use the same trick for report filed in the pivot table? I am using Office 2010, and in Report Filed Filter showing only one search bar, not showing these options.

Very useful...tnx

tysm

Very good, thx

Thanks😀

Why not just stick the data in a table

katabian nga content creator.

The video is not at all clear !!

too much talking!