Delete Rows if cell value in a column are blank

Greetings!

I am trying to delete all rows of a excel table, if cell value in 'Column F5' onwards is blank.

There are more than 3000 rows of records and data is sorted with blank columns at the end of the table.

For example:

In the attached .jpeg file, column C has blank cells from C9:C, and hence would like to DELETE all the rows from 9 through 3000 rows.

Any advise, would be of great help!

Thank much in advance.