Table 1 to Table 2 Insert

INSERT INTO table_2 (id, name, address, state) VALUES (1, ( SELECT curr_value FROM table_1 WHERE id = 1 AND path = 'name'), ( SELECT curr_value FROM table_1 WHERE id = 2 AND path = 'address'), NULL), (2, NULL, ( SELECT curr_value FROM table_1 WHERE id = 2 AND path = 'address'), NULL), (3, ( SELECT curr_value FROM table_1 WHERE id = 3 AND path = 'name'), NULL, NULL);