I Dont want Blank cell in Drop Down cell.

Hello all,

Hope you all will be fine..I m back again cuz some thing stuck me and needs your help to solve it..

As per attached example file..i have a dropdown cell in sheet 2 cell D2, which gets a name from a list as i fix in validation"Name".

I have problem when i click drop down, i list appears but it consist of blank cells also and not uniform in order from a to z..

What i want is if i click D2, a list should come duly uniromed and without blank cells or rows.. Can it possible? cuz my mind is not working here..

Thanks in advance for any help.