Get data from database and put it back to a new datasheet I want to get the data from the database and put it back with the new format

I have a lot of datasheet like follow

ID a b c  d
1  1 5 9  13
2  2 6 10 14
3  3 7 11 15
4  4 8 12 16


and I want to put it in a new datasheet like follow

ID a b c 
1  1 5 9
2  1 5 9
3  1 5 9


and the second sheet's data's column C can be the column D like

ID a b c d
1 1 5 9 10
2 1 5 9 10
3 1 5 9 10


how to make the SQL?
This returns the results you you specified, but I'm not sure it returns the results you want.  It was built on Oracle, so you may need to modify the syntax slightly and of course the table names.

CREATE TABLE T1 (ID Number(3), A Number(3), B Number(3), C Number(3), D Number(3));
CREATE TABLE T2 (ID Number(3), A Number(3), B Number(3), C Number(3));
CREATE TABLE T3 (ID Number(3), A Number(3), B Number(3), C Number(3), D Number(3));

INSERT INTO T1 values (1, 1, 5,  9, 13);
INSERT INTO T1 values (2, 2, 6, 10, 14);
INSERT INTO T1 values (3, 3, 7, 11, 15);
INSERT INTO T1 values (4, 4, 8, 12, 16);

INSERT INTO T2 (
   SELECT T1B.ID, T1A.A, T1A.B, T1A.C FROM T1 T1A
   CROSS JOIN T1 T1B
   WHERE T1A.ID=1 
);

INSERT INTO T3 (
   SELECT T1B.ID, T1A.A, T1A.B, T1A.C, (SELECT T1C.C FROM T1 T1C WHERE T1C.ID=2) 
   FROM T1 T1A
   CROSS JOIN T1 T1B
   WHERE T1A.ID=1 
);

SELECT * FROM T2;
SELECT * FROM T3;