Is there any way to autofilter some different ranges for nonblank cells
at different vertical points on a sheet?

I dont normally use this type of thing, but it needs to be automatic as
the data coming in will change.

Specifically I want to filter a list of data (5500 entries) to show
only those rows with data in a certain column, and at the bottom in a
seperate Split, do it again.

Thanks