I've been given an excel spreadsheet with useful names, numbers and emails for work, but the genius who created it put the office name in A1, telephone number in A2, contact name in A3, title in A4 etc

Is there an easy way to move all the different info into different columns so i end up with a line for each contact name, under the individual offices?

I tried a simple drag,and copy thinking I could then delete the extra lines, but they don't all have the same number of lines, so i guess I'm looking for something to say if A6 begins 01, copy to D2 or similar, then I can use the same formula for 07, titles, etc?