Data in Excel with no header columns

Can I do select range from source, to select all data rows and paste in target at the specific row as there is already some data in there? What will be the exact steps?

Thank you,