Converting rows of data in notepad to columns

Hello,

Needing help please. From a pdf data base supplied, I have copied the contents over onto notepad. The data within this notepad contains first name, last name, postal address and a whole host of other non related data. The challenge is that the data exists in "rows", and I need to import into excel in column format-that way I can clean up the unecessary data and continue with my mail merge. Sample of data in present format:

943850========================================

App. Name One: Anonymous Mr Dec 15, 1963
App. Name Two:
Corp. Name:
Address: PLOT 99 Witels Street


DELFT 7100
Business Entity: 570 South Africa Language:
E-mail Address:
Home Phone: Work Phone: 0799172800
Mobile Phone:

Can anybody help?