copying table field data to another table field

Question

how can i copy from one field entry data to another table fields....in sql database

 

i have one table known as productdetails and its field ProductName

i want new table from Productdetails Table field  known productDescription and its field productName1,ProductName2......productnameN(its contain value of ProductName column)

please help me..