Something like this would work. I included the table DDL for clarity:

CREATE TABLE TABLE1 (FULLNAME VARCHAR(20), EMAIL VARCHAR(30))

CREATE TABLE TABLE2 (IDEN NUMERIC(12) IDENTITY(1,1), FULLNAME VARCHAR(20), EMAIL VARCHAR(30))

INSERT INTO TABLE2 (FULLNAME, EMAIL)

SELECT FULLNAME, EMAIL FROM TABLE1