http://www.newtechcity.net/files/Extracted%20Data.xls

I extracted the data out of the main excel file and put them in columns
a-d so I didn't have to upload the entire file which is well over
100mbs. You can better understand exactly what I want to do. Columns A
& B need to match up zip code for zip code, for example A5 & B5 match,
but A10 should match B6. Manually I would have to drag and drop cells
for the entire file which will take a very long time. Therefore, I’m
wondering if there is a way to make the data from Column B match A. The
data for Columns C & D would also have to shift as well. Let me know,
thanks!


--
mikemillsjr
------------------------------------------------------------------------
mikemillsjr's Profile: http://www.excelforum.com/member.php...o&userid=29749
View this thread: http://www.excelforum.com/showthread...hreadid=494641