I've got a problem where I have two emailing lists, each one nearly 4000 lines long, that need to be compared and merged. One is updated and includes more people, but the other includes opt-out preferences of the original batch of 3800+. The documents aren't even close to the same in terms of columns (one includes mailing addresses and separated first/last names while the other has first/last names together and only e-mail addresses) and I'm at a loss as to how I can combine these two files... The only column that would allow me to do a duplicate search for a compare process would be the email address column, which is okay. I could actually probably delete the other columns in both documents because they don't matter in these lists anyway. Any suggestions?