Merge 2 different Excel In 1st excel

This work but i also want to copy the 1st row of excel1 till column Service_Period until it reach empty row.