Replace columns in DataTable and by the way insert at specified position (code snippet)

DataTable table = GetSomeDataTable();

table.Columns.Add("NewNumber", typeof(int)).SetOrdinal(table.Columns["OldColumn1"].Ordinal);

table.Columns.Add("NewText", typeof(string)).SetOrdinal(table.Columns["OldColumn2"].Ordinal);

foreach (DataRow row in table.Rows)

{

  row["NewNumber"] = Transform1(row["OldColumn1"]);

  row["NewText"] = Transform2(row["OldColumn2"]);

}

table.Columns.Remove("OldColumn1");
table.Columns.Remove("OldColumn2");