I have a spreadsheet in which columns E - I are references to column C and
may or may not contain data (one to one or one to many). I would like to
insert a new row, copying the data in A - D for each time there is data
contiained in columns E - I.

ex. (Would want to see as three rows for data in E, F and I)
A B C D E F
G H I
Client Manager Control# Control Name Code1 Code2 Blank Blank
Code3