Do you mean that you want to Add the data from one table in to another table to delete one of the tables?
As Duplicating data is not recommended.