Don't display empty values in Data Validation

Hello everyone.   I have attached the sheet where I have the problem I am about to present to you.   In cell "G1" I entered a "Data Validation" list of the range "$D$2:$D$500". However, from cel...