Rearrange some data sheets

Hey!
Got a shitload of excel documents with contacts, adresses etc in the order shown below
i want to rearrange them in the order shown at the bottom, how do i do this in the most efficient way.

Each excel got from 1-500 customers and in order for me to import them to my database i need to rearrange the order in the excels. please show me how.

[collumn 1]
Random guy
Randomstreet 11
183 34 Randomcity
mobile nr 070 xxx xxx xxx

Random girl
Randomstreet 11
183 34 Randomcity
mobile nr 070 xxx xxx xxx

This is how i want it to look
------[collumn 1]-----[collumn 2]-----[collumn 3]---[collumn 4]---[collumn 5]
row 1-----Name--------Adress---------zipcode--------city------------phone nr
row 2-----Name--------Adress---------zipcode--------city------------phone nr

Zipcode ofc being the 183 34 number