I have a spreadsheet with thousands of rows. In column J, there is data in some rows, but not all.

What would be the best way of selecting every (entire) row that DOES have data in row J? I would like them all selected at the same time to move them to a different spreadsheet.

I'm guessing a macro would be the easiest way, but I'm not too sure where to start. Some sort of loop function?