I need to automate a database cleaning process in Excel
$10-30 USD
S-au achitat serviciile după ce au fost prestate
I need to automate a base cleaning process that consists of the following:
Initially you have to delete some columns that I don't need and leave only what I need.
After that I have to separate the entire row into a different file depending on a field in a cell.
For example
I have a base that has:
Name | Phone | Email Favorite color |
And I only need that in my exported sheets at the end this Mail and Favorite Color
On one page, all the people with a favorite color "red" should come with their email (only those two columns, the others should be deleted), in another file, all the people with a favorite color "green" with their email, in another those of the color "blue" ... etc
ID Proiect: #29363143
Detalii despre proiect
40 freelanceri plasează o ofertă medie de 20$ pentru proiect
Hi there, I have understood the Project I can develop a simple macro for this, it will delete the rows or columns that need deletion and prepare a seperate Excel file within which we can have sheets based on colour. Mai multe
Hello I'm an excel professional experienced in these sort of automation. can we discuss your request? John
Hi there, I can help you with your database cleaning project based on your requirements . I have 7+ years of expertise in Excel/VBA, SQL, Power BI, Tableau creating complex automation tools, formulas, databases, qu Mai multe
Hello, I went thru the description Contact me and I will start the task RIGHT NOW I look forward to hearing from you Thanks Regards Thushara
Hi, I'm interested on this post. I have an advanced knowledge on Excel's different formulas including pivot charts and visual basic coding. I can help you finish this work as soon as possible.
Hi there, I am an expert in excel, database programming, Access, VBA and data processing. In this regard, I am going to automate the process of cleaning your data as you have described. I am ready to start working on y Mai multe
I have more than 5 years experience in typing & expert in Web designing. Also an Educator & Having good typing speed, knowledge of relevant computer applications, attention to detail and accuracy, written comprehension Mai multe
I see you need some help in data cleaning automation. I will be pleased to work with you :) I'm a certified data analyst, I have a nanodegree in advanced data analysis and statistics. I worked on data analysis in pyth Mai multe
I have gone through your project details and I am sure that I will accomplish it. So, I am ready are you. see in you in the inbox to get it done ASAP. your regards Abhishek
Hello! Sir, I can understand your work. I am professional and very efficient in data entry working. I can complete your task within the timeframe. Customer services are my first priority. My primary goal is to satisf Mai multe
Hello! I have been using Excel since my university projects. So I believe that I can Handel your project effectively.
Greeting Sir, Hi ,My name is Noor Ariffah Chung Abdullah. I know excel ,word and different types of skills of typing and data entries. I can do all types of work in excel. Hence, I can say that I am data entry expert Mai multe
Hi Thank you for your project description I love to work with you. I have understood what you want and how to deliver quality work to you Thank you sincerely Bibek tamang https://www.freelancer.com/u/Ben123Ben123 Mai multe
Hi, This is Jaimin Patel. I have earned Diploma in Information technology . I have done such work in past. So, I am able to do such work in time frame.
Hello sir I am interesting for the job. I am computer operator. I have expert team. I have 4 years experience.
Hi, I read your project details and want to work for you. I can easily do your job. If you want hire me then please accept my proposal. Thank you, vijendra singh
Hello sir I am interesting for the job. I am computer operator. I have expert team. I have 4 years experience.