HOW TO SPLIT ONE ROW INTO TWO ROWS
 

I have a spreadsheet which is a planning schedule. It comes from a different
worksheet from which I take data for the first "X" of columns.
I want my planning schedule to break one row into two once the information
is imported from the original workbook so I can put planned time in one
colour (one ro) and the real progress in the second row different colour.
A1 B1 C1
D1 ORDER NUMBER CUSTOMER NAME START DATE DUE
DATE

After this colums I want the row to break into two rows? Is there any way I
can aply this to the entire worksheet?.

Thanks