Only shows rows whose cells in a specific column have values

[Ian Y]

Say I only want to see rows whose cells in column B have values. That is, hide rows whose cells in column B are empty.

Is it possible to achieve that with function or Filter?

 

[alansidman]

In Filter, uncheck the box for blanks in Column B