Data Cleaning and Coding
Budget $8-15 AUD / time
I'm a PhD student wanting to outsource some data cleaning. I have a small amount of Excel data that needs to be re-coded in several ways and turned into an access database. I expect I will have a lot more work to offer as this project progresses.
There is name data in the format "John Smith" that needs to be converted to "John_Smith". The data is a 2 column set of relationship data (Column A has relationship with corresponding cell in Column B). An individual ID code needs to be attached to every unique name appearing in the data and another unique code to every relationship Then an access database with approximately 5 fields needs to be created from the Excel data.
Tildelt til:
Hello there, I am well-versed in excel. I can help you with this task. Looking to hearing from you soon.
13 freelancere byder i gennemsnit $11/time for dette job
Please provide sample excel [url removed, login to view] clarify some points 1- Are all names in the format Firstname space Lastname (John Smith) ? we can write code (VBA) to replace space with underscore(_). 2- Please Flere
Dear Hiring Manager, Over all 15 years of IT industry experience. Development of Web Application and Windows bases Application using Microsoft Technologies Knowledge and experience of following tools o Visual St Flere
Hello Sir, Thanks for the requirements, I can do perform following activities : 1) Date Separation using Excel related functions, ( VLookUp, HLookUp, Conditional Formatting, Text To Column, If etc) 2) Excel VBA M Flere
Hi, I worked as an auditor/accountant for 9 meaningful years and now a full-time freelancer. I believed that my excel expertise could help you for this work. Part of our daily task is to work on an excel for the easy c Flere
I can design and create any macro or vba code in MS Excel. Waiting for your service. Thankyou.