Avoiding empty rows when copying between sheets

In one sheet I have several columns of data. Right now I am using this formula to copy data that fulfills a certain criteria:

=IF('Sheet1'!A1>=10, 'Sheet1'!A1, "")

But by pasting this down, I end up with lots of blank rows where Sheet1 Column A is less than 10.

Any suggestions as to how to paste this data while avoiding empty rows?

you could filter on column A and copy the filtered data to a blank worksheet. You could record the process in a macro to make it easier if it's a regular task.

Regards