I was wondering if anyone could help me.

I have on one sheet a product selector for my sales team. I have added a
column where they can put an "x" into if they would like to quote that
product to a client. I have created another sheet called "Quote" where the
prodcut details are automatically updated from the "Product Selector".
However if they choose the products listed in ROW 1, 5 and 7 they are copied
the same way to the quote with blank lines in between. How can I make sure
that they are copied over but without the blank lines?

I hope this makes sense.
Thanks