Which task(s) do I use to transfer data from a table to two other tables, breaking up the columns in order to achieve normalization?

This would necessitate reading the just created identity field and transferring it to yet a third table that is a translation table.

Thanks much for any advice you can lend.:)

Bob