I have 2,500+ columns of cells that I have defined names so they can be used for conditional drop downs (i.e. if cell F10 = XXX, the drop down list in another cell only applies to what is in F10). Where I have listed my drop down options (the 2,500+ columns) some of them have multiple options and others have 1.
The problem I am trying to solve: Some of my drop down options have multiple blank lines.
Is there a way to not include blank lines without having to go through each column?
The problem I am trying to solve: Some of my drop down options have multiple blank lines.
Is there a way to not include blank lines without having to go through each column?