Cannot associate info. from one cell to another, repeatedly

[ashvin83]

Hey guys,

I'm trying to associate information from a cell of one column to a cell of another column of the same row. An example is below:

cell A1: x
cell B1: y

This would be easy to do if i had just one set of these associations (and not necessarily just x and y) but given that I will likely have up to a thousand, I need an alternative to copying and pasting. I looked into macros but no luck there. By the way, i'm using 2003.