Excel import yields double spacing

There is. It may be a bit of work, but here is the way I would approach this. Assuming the file size is not prohibitive, I would first select Data > Filter > Autofilter. Then I would go to the first line Column A, select the pulldown arrow, and choose (NonBlanks). If that is not sufficient to select only the rows you want, I would adjust my column selection until I had hidden all the unwanted rows. If you need to remove the filters, you could then copy the remaining rows and insert them into a new worksheet.

One word of caution: Hiding rows based upon the value of a single cell in that row could cause you to hide data unintentionally. To check for that, change your filters to (Blanks) and see what appears. You might need to make some more adjustments to the selected columns.