Hiii..

I have created an excel table with two columns (1st column has 10 items & 2nd one has 6 items).

Now I am using this table (2nd column) to create a Data validation list for drop down.

I have used the following formula in the source list : =Indirect("Table1[column2]") to get all the 6 items dropdown.

Issue is the dropdown has 4 blank rows below as the table 1st column has 10 items in it.

I want to exlcude those 4 blank rows from the dropdown.

What is the solution?

Thank you.