You know you want to fill the empty cells with values, but how do you do it quickly? Perhaps you copied data from a report somewhere, and some columns were summarised with blank spaces sorta like the spreadsheet below.
https://www.businessprogrammer.com/fill-empty-cells-in-excel-with-value-above/