Google Sheets add new row if cell contains text

I'm trying to find a way to add a new row when an empty cell is filled in. At the moment there is an empty row on row 15. If text is added to cell A15 i'd like another empty row to be added so there is always a blank row above the dark gray separator. The same would go for A22 and other cells on the sheet.

Thanks in advance Rich

Sheet screenshot

Read more here:

Content Attribution

This content was originally published by Rich Astley at Recent Questions - Stack Overflow, and is syndicated here via their RSS feed. You can read the original post over there.

%d bloggers like this: