How to make table 2 using table 1 with INSERT only

How to make table 2 using table 1 with INSERT only

Table 1:

Table 2:

Is that possible?