I have a table where column A looks like:

1. o.c. < 700 mm
2. <empty cell>
3. o.c. >= 700 mm
4. <empty cell>
5. o.c. < 700 mm with...
6. <empty cell>
7. o.c. >= 700 mm with...
8. <empty cell>

I want to create a validation (ie. a drop down list) that only includes cells that are filled with information (ie. do not want blank cells).


Thank you