Copy and remove duplicates

[JimJx]

Hi everyone.

I have a table that I need to add a lot of new data into. But there are a couple of problems with that.....

First, the new data is not completely compatible with the old so I need to copy data from one column to another, if the second column is blank. I also need to make sure that there are no duplicate entries.

I am using MySQL version 5 and I am not real sure how to proceed.

Any suggestions are greatly appreciated.
Jim

[BrainDonor]

How is it not compatible? Different data types? Can you provide some example data and an idea of what your table structure is?