And when I run NoSparks code after adding the header, it works well, but only for about the first half of the spreadsheet. Then the last half of the spreadsheet removes the text from the first rows completely. The spreadsheet then looks like this...

A1: coffee B1: creamer
A2: cups
A3: etc.

What could be making the script work for about half of the spreadsheet but not the whole thing?