Charles thanks...I was able to get the macro to run after you changed it, but it's not working right. Instead of making..

A1: coffee
A2: creamer

A4: straws
A5: cups

Look like this..

A1: coffee B1: creamer
A2: straws B2: cups


It's doing this..

A1: creamer B3: coffee
A2: cups B4: straws


..All the text from the second rows are only in column A and all the text from the first rows are in column B down the spreadsheet.

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?