How to avoid blank records/ rows in dashboard data (Excel)

Hello,

In general we are facing this issue , ” How to avoid blank records/ rows in dashboards”

If source is having some 30 records and  in which some records are blank…then how to avoid that blank record .

Please find the attached Excels sheet. Same excel logic you can apply on your dashboard data (Excel). I tried the same and it is working perfectly.: