Data Entry Project Excel Data Organization - repost 2

I need all of the attached data to be in the format of training1st+%281%[login to view URL] (also attached). I have taken the data from the coordinating PDF's and converted it to an excel spreadsheet; however, the data still needs to be organized in the same fashion as training1st+%281%29.xlsx. For an excel expert, this shouldn't be a very difficult task. I would like the project finished by tomorrow. If you know Visual Basic, it would make this project even easier. Almost half of the list is already finished. The rest of the contacts need to be put on the training1st+%281%[login to view URL] in the same format that it is seen. Please only respond if you can do this within 24 hours. The last two people that have bid on this project, have promised me that they could do the job and have both aborted it. I WILL ONLY PICK THE TEAM THAT ACTUALLY READS THIS AND INDICATES THAT THEY HAVE READ THE DETAILS ON A PM.