|what are you using this equation for, if organizing infomation, i recomend marking the data in sheet 2 with some kind of marker, then move the two of them, the name and the marker, to sheet 1|
this will move both the sets of data to sheet 1
highlight the two rows and then select the botton on the top of the window that is an A on top of a Z with an arrow pointing down. this organizes the infomation, moving the blanks to the end and the cells with infomation to the top.
hope that helps