If this helped you out at all, maybe buy me a coffee? (recently got laid off over here)
https://ko-fi.com/matrock

How to use Find and Replace to search for and replace blank cells with any thing you want.
Here’s you’re new best friend: ^//s*$

There are instances where an array formula would be better, but for a lot of simple cases this method is faster and works just fine 🙂

Please take the opportunity to connect and share this video with your friends and family if you find it useful.