The row should disappear:

-
Click and drag down the row headings for rows 9 through 15.
Right-click the highlighted rows and delete them.
-
Insert a new column in front of column F.
-
Insert a new column in front of column H.
-
Insert two new rows above row 3.