Into E9, enter the formula
Code:
=IF(ISODD(ROW()),"S.P.C. BAR TO","IPC Connection TO")
and copy down as much as you need.
This assumes those texts are repeated for every row in copied range.
In case you need fields in intermediate rows empty (i.e. the pair of rows is repeated after 7 next rows), The formula will be like
Code:
=IF((ROW()-9)/7=INT((ROW()-9)/7),"S.P.C. BAR TO",IF((ROW()-10)/7=INT((ROW()-10)/7),"IPC Connection TO",""))