I need help formatting an Excel sheet

I need help formatting an Excel sheet

Im trying to create a database from this website:
http://www.fifa.com/aboutfifa/organisation/footballgovernance/playeragents/list.html
Each country has loads of agents, with contact details next to their
name.(Fax Number and Company name are not required)
The problem is, due to the format of the website
(http://www.fifa.com/aboutfifa/organisation/footballgovernance/playeragents/association=alb.html),
when I copy the data into my Excel sheet each Agent has information spread
over 3 or 4 rows. (Sorry for No pictures, I'm new so have no reputation)
I need each Agent to have all their information on one row,
eg.(Cells in Brackets)
(A1) GRO Alberti (B1) alerti.ago@got.ch (C1) Bosnia (D1) P Hora K2 A 8 41
Dhjetori (E1)Girana (F1) Tel:+42-79/379 82 86.
I tried copy pasting it all manually, but this takes far too long.
Is there any automatic or quicker way of achieving what Im trying to do?
Thank you for any help, it is much appreciated.