Filtering with blank rows between data

Hi

In the attached doc in the assortment sheet I am looking to filter data.
Example. If I were to create a filter and select supplier (column I). I would like to view all rows applicable to this particular supplier.
At the moment I am only able to view the rows up to the end of the 1st months data.

The problem is the sheet is setup by month where I have gaps and spaces between each month. These spaces are required as new data is constantly added.

Any suggestions?

just select the whole data and then make filter tab dear

so easy - thank you!

YW dear