Copy Paste Excel data plus some typing - Data Entry

Please see attached excel file. see sample file first I have a list of 100 such colleges in other file I want data from this excel copied over to another excel file in following proper format collegename , Personname , Title\Job , Phone ,Email Most of the colleges are in proper format,see college 1 - Georgia . Only missing here is collegename in first name. so user will copy that as first column in another excel and copy other data next to it. Second example is little more complex - College of HolyCross here email is hidden under 4th column , keep mouse over EMAIL column to see email . in such case email has to be typed Third example is little simpler , Howard University here only fax is extra which has to be removed. This is a good project for a group who can divide the work and do it fast. No problem even if you are working alone as long as are good in excel and can complete this job fast , maybe 25 colleges each day to complete 100 Also good to get a good rating on rentacoder ## Deliverables 1. Completed Excel file * * *This broadcast message was sent to all bidders on Wednesday Feb 13, 2008 8:19:43 PM: i have now changed attachment in main bid. It now contains actual file. please have a look * * *This broadcast message was sent to all bidders on Thursday Feb 14, 2008 2:25:55 AM: By mistake I wrote that in case email is under a link then you have to type in the email , this is not required as long as when you keep mouse on top of the link if it shows emailid in hint popup then its ok, for example see sample file for example 2 , here email is under email and not shown , so here copying the cell which says email is enough so this means much less work is involved now ## Platform excel