Vacant line in drop down list

Question

I am trying to build a drop-down list from a range of cells: D5:J5

D5:F5 are Merged

G5:I5 are Merged

J5:L5 are Merged

Using the following:

My Drop-down is showing a gap between Action 1 and Action 2.

What am I doing wrong?

Thanks

riny_van_eekelen · Answer

robejohg&nbsp;What am I doing wrong?&nbsp;you are using merged cells! Don't.&nbsp;But now why it happens. The data validation list includes all values it finds in the range D5:J5 but eliminates duplicates. So that's a first text, an empty field, a second text and a third text. The empty fields come from columns E, F, H and I.&nbsp;&nbsp;

robejohg · Answer

That did it.Thanks

Forum Discussion

Vacant line in drop down list