Click on the data in the pasteboard. Paste it all into the Pasteboard.
Then batch copy into the pasteboard. Select the cells you want to paste and click on the data in the pasteboard. Then you can copy in bulk.