How to exclude blank cell from drop down list.

I have a blank cell at the bottom of the drop down menu, I don't want any blank cells to show. I gave the following formula in data validation, but did not accept.

=FILTER(INDEX($D$3:$J$8,,MATCH(L2,$D$2#,0)),INDEX($D$3:$J$8,,MATCH(L2,$D$2#,0))<>"")

Looking for a solution with non-volatile formula. Because I have to use this draggable formula a lot of times in my worksheet.

Someone help me please.

Please try Name manager

List
=LET(z,XLOOKUP(L2,D2#,$D$3:$J$8),INDEX(z,1):INDEX(z,COUNTA(z)))

or
=XLOOKUP(L2,$A$2:$A$14,$B$2:$B$14):XLOOKUP(L2,$A$2:$A$14,$B$2:$B$14,,,-1)

Data validation
=List


Data validation must refer to range. FILTER function return Array.

or
=OFFSET($D$3,,MATCH(L2,$D$2#,)-1,COUNTA(INDEX($D$3:$J$8,,MATCH(L2,$D$2#,))))