Every time I create a dependent dynamic drop-down list, there are a lot of blank cells in the drop-down list. I look for numerous topics that describe how to get rid of these blank cells by adding two more ranges, as she did.
http://blog.contextures.com/archives/2014/02/27/dynamic-list-with-blank-cells/
But my concern is: Is there a straightforward way to eliminate blank cells or get rid of them without utilizing two more ranges or a complicated formula?