not clear about your question. my opinion for this question that if your column contain same value that you want to copy so no need to copy just add field with different alise for example
SELECT ID, Name, Name as stdName, Address from table1
execute thsi qry you can see the Name field conten with two column one is Name another is stdName
try this.
Thanks