Can someone please help.

On my spreadsheet I import data from a vehicle tracking application using
data import (it produces one line for each journey). As the number of
jouirneys varies so does the number of lines. From the imported data I copy
it to get it to appear as I want. The problem is that on the output data
area when there are only a few journeys I get lots of rows of rows of zero's.
Is there a way to make the output data area expand and contract with the
input data area?