Removing blanks in a dynamic list range

Hello,

How do I remove blanks from a dynamic range in Google sheets?

The range is based upon a formula rather than direct entries.

I have tried looking around the web and the solutions I have do not seem to work.


I will post up an example later.

Hi, i need your help.
I use excel 2003.
I have a column with alphanumeric values which i change often.
I would like to dynamic create and update a new column without the blank cells