Help in Insert Excel command

[SmithToronto]

Hi,
I have following Excel data. How I can get the desired result in D2,D3 and D4 columns. If any column has NULL or blank then values should be '' in Insert command, as mentioned in the D columns

A1 B1 C1
1 E AAA
2 E BBB
3
A1 B1 C1 D1
1 E AAA Insert into TPG (A1, B1, C1) values ((Select max(A1)+1 from DIC),'E','AAA')
2 E BBB Insert into TPG (A1, B1, C1) values ((Select max(A1)+2 from DIC),'E','AAA')
3 Insert into TPG (A1, B1, C1) values ((Select max(A1)+3 from DIC),'','')

 

[SmithToronto]

Here is the screenshot image.