Fill in a Spreadsheet with Data

I'm going to provide you with a list of 300 investment banks. What I need you to do is find the contact information of an associate and a managing director that works at that bank. 1 associate per bank and 1 managing partner per bank. You must specify the region that he works in. Emails must be accurate, working and I will quickly verify this with mail merge function on excel. All emails will pretty much look like [login to view URL]@ [login to view URL] [login to view URL]@ [login to view URL] [login to view URL]@ [login to view URL] etc. Rules that must be respected for the project: -Alphabetical order for the bank names -You must specify type of bank: "investment banking" or "asset management" -Many of the banks operate in SEVERAL different regions. You must treat each region as a different entry. For example: Goldman Sachs Montreal, Toronto, New York and Los Angeles. -Separate offices by region. You will use these regions: Toronto, Montreal, New York, Los Angeles.