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.