Fix Five Misaligned CSV Spreadsheets

I have a few CSV spreadsheets that have information misaligned. I need the spreadsheets fixed so that similar information is found in the same columns (such as name and email address). There are five spreadsheets that need fixing. See the attachments for examples.

I need two things done with each. I need full names split into FirstName and LastName, and I need email addresses for each (some do not have an email address listed, in which case the entry can be deleted). The email addresses appear in scattered columns throughout the spreadsheet, so emails need to be captured in a precise manner for each row.

I have a very short timeline to complete this. But because it will likely take some simple macro coding, I am told it should be quick, easy, and straight-forward.

スキル： 情報処理, エクセル, PHP, ソフトウェアアーキテクチャ, ビジュアルベーシック

さらに表示： repair csv file online, how to corrupt a csv file, check csv file for errors, csv cleanup tool, open csv file in excel without formatting, fix csv file, problems with csv files, csv null vs empty, Get Data Entry Done - 09/03/2017 23:54 EST, logo design - 08/03/2017 16:15 EST, Fix the CSV bulk import in my website, i need an excel expert to come and fix up our spreadsheets for a few days johannesburg, freelancer freeroll 2016.04 03 pasword, 07.04 16 freelancer, ajax csv cross domain fix, csv excel sample spreadsheets, csv database fix, upload csv fix, php fix csv file, fix csv mysql

プロジェクトID: #16420130