google sheets – How to split two-line rows into separate rows

Editable spreadsheet here:

You can see each non-blank row contains two lines. I’m trying to find a way to split these lines into separate rows. Columns C and I do not have two lines of text, I’m fine with sticking that text in one of the split rows or duplicating the content into both rows.

I add new data daily, so ideally a script that I could run daily to split the newest content that I have added to the bottom of the sheet.

enter image description here