Add a filter but range includes blank rows?

[Melimob]

HI

I am struggling with this.

Is there any way to add a filter to disregard the blank columns but still ensure I am reading to last row of data?

I was thinking I need to do an xlup function? can I only apply the filter this way using VBA?

thanks for any advice.