Filter concise list

I have a dynamic range which changes every month. Range includes blank which I want to ignore. Is there a filter function which I can pull only non-blank values but ignore the blanks? I want the output in a table, which should also expand as needed of course.

thanks

You can use

Formula:

Please Login or Register  to view this content.

which will expand/contract as needed, but it will not work in a table.
As far as I know, there is no way of making a table expand/contract in the way that you want (at least not without vba).