excel - how to frame a insert query with values in A cell -

i have spreadsheet values

 1000 2000 3000 4000 

i want frame query like

insert table_name values(a1); insert table_name values(a2); insert table_name values(a3); 

how can this

you looking function concatenate()
=concatenate("insert table table_name values(",a2,");")
here a2 cell in value contained.
step 1> goto column beside 1 values
step 2> apply above formula
step 3> copy paste formula cells in new column. take care of generating final values.