Reading rows which are empty

Yes got it! Thank you for this!

I am also looking to write text to the next empty cell on excel. would you be able to guide with this please?