I have multiple CSV files with three worksheets of data (see sample) that I need merged into a single, "master" Excel file. Attached is a sample of the raw data saved as an Excel file with the columns I wish to retain marked in red. Please filter out any records with Subsidiary value. Please also convert text fields like Company Name, web address, address to normal case. I have 28 of these CSV files that will need to be merged to a single Excel file. Also note that the leading zero in the zip code field must be retained. Please work on the sample file below first to demonstrate you understand the project.
Budget: $35
Posted On: March 13, 2017 17:31 UTC
Category: Admin Support > Data Entry
Skills: Microsoft Excel
Country: United States
click to apply
Apply Now: All jobs | upwork.com http://bit.ly/2nx2K8q
No comments:
Post a Comment