To quickly fill blanks with the value from a cell above: Select the range of cells with blank cells (this range is typically in one column). Press Ctrl + G to display the Go To dialog box and then click Special to display the Go To Special dialog box.
https://www.avantixlearning.ca/microsoft-excel/quickly-fill-missing-values-cell-excel/