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.
Hello, I have experience in excel work. I can do this project. Please check my reviews. I can do this project with accuracy. I am ready to start Now. Please review my bid. Thanks. Manish