Excel: Please how to i arrange and transfer this data into spread sheet.

1. John blue, 12 pop road, well, devon, london.
2. Adam blue, 13 pop road, well, devon, london
3. Carlos blue, 14 pop road, well, devon, london
4. Luke blue, 15 pop road, well, devon, london
5. Dean blue, 16 pop road, well, devon, london
6. James blue, 17 pop road, well, devon, london
7. Joe blue, 18 pop road, well, devon, london
8. Pat blue, 20 pop road, well, devon, london

If you try copy and paste, you will find out that it never fit the data page.