' it pastes all the information into cell A1 '
Usualy when you paste data over to Excel, all the data is pasted in column A. So the rows are there but the column are not. Is this the case with you or did it really paste all the data in one cell A1?
'There are 2,899 registrations'
' need them to be listed into rows of 11'
'The range would therefore be A1:J2,900'
So I guess instead of rows you mean columns. But then you would end up with column K instead of J. Kind of confusing.
Are you familiar with the text delimiter option? You can find it under the Data tab. It will let you spread your data across columns based on spaces (amongst other options).