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?