> =CONCATENATE("INSERT INTO myTable VALUES (",a1,","a2");")
This is so neat. Supposing you are not migrating from a spreadsheet because it got too big (millions of rows will take a time for this to finish) and that your data respects a logical grouping, this is very handy.