I have to manually add this information in order to complete the analyses required. Is there a better way to fill these blank cells? A. I have created an example spreadsheet to mimic the issue ...

1. How to highlight blank cells in Excel Blank cells are easy to miss if you’re working with a lot of data, so you might want to highlight them. The best way to do so is with a conditional format.

Excel uses blanks to determine ranges, so its selection-based features won’t work as expected if there are blank rows anywhere in your data set.