please how can i arrange this data into excel

Name: John blue
Add : Iron Street
code: 25252
Country: uk
,
Name: John blue
Add : Iron Street
code: 25252
Country: uk
,
Name: John blue
Add : Iron Street
code: 25252
Country: uk
,
Name: John blue
Add : Iron Street
code: 25252
Country: uk

Going down to like 4000 records in Text format. I needed to transfer the data into excel. But i did import the data into excel but when i transpose, all the record stays in a single column. Can i have the data to be in data row.
Please help