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.