I have a spreadsheet that has 1 column of data. It looks as follows...

1314 (sequence #)
070607 (date)
12345678911 (upc)
999 (price)
11987654321 (upc 2)
888 (price 2)

I need the macro to take the sequence # which is always in cell a 1 and fill
to the end in column A. In column B I need it to do the same thing with the
date. Column C needs to have upc, upc2 and so on. Column D would then have
price, price 2 and so on.

In the file the upc is listed first and then below it is its corresponding
price. Then it moves to the next upc and price. Any help would be great.

Mike