Forum Discussion
Trying to remember a function to add a row below if the row above has data
Working on creating a massive calculation spreadsheet (75 sheets). The only formula we are missing is the one where if there is data on the line above, the final sheet will automatically add a row be...
If you're looking to essentially 'fill in gaps in the data' then you have a few options. You could use Go to Special to identify blanks and fill with value from above.
The method is described here.
How to fill blank cells with value above / below / left / right in Excel? (extendoffice.com)
If you have 365 and want a formula:
=SCAN("",D1:D13,LAMBDA(a,v,IF(v="",a,v)))