Change excel data from one format into another
$10-30 USD
Оплачується при отриманні
Sheet one has 74 foods in spanish, each of which has 2 or 3 codes laid out horizontally, and for each code, there is a quantity value below it.
The foods are highlighted yellow, the codes are highlighted grey and the quantities are white.
Sheet two has a list of IDs and Foods (in spanish). It also has an empty column for codes and another one for quantity.
What needs to be done:
1) Data in sheet 1 needs to be matched to the data in sheet two. For each food, the codes and quantity need to be added vertically (add new rows as needed). The first few rows have been done to show what is needed
2) The codes shouldn't have any spaces. In some cases they appear with spaces in the first sheet e.g. "12 x 3". These should appear in the second sheet without spaces e.g. "12x3"
3) Finally, the codes and crop names need to be copied to the new rows that were added (this has been done with the first few rows too)
ID Проекту: #5011838
Про проект
Доручено:
This si an easy task. I will provide a VBA macro that you can use for future needs. All will be done automaticaly. No manual task and the macro can be used later. Waiting for your reply and ready to start. Thanks
13 фрілансерів(-и) готові виконати цю роботу у середньому за $24
Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply. Lets start.
Hello, I have done many similar jobs before, I can help you with this. 100% accuracy. Thank you, Elvira
Hello,i can do this for you,and can start right,check my reviews to see it will all work fine. Regards, Bojan
Good day, I am expert. I teach excel. I can say there is no formula in excel that I cannot handle it. I've got lots of experiences in excel automating and conditional formatting. Here are the links for my past experie Більше
I have gone through the attached excel sheet. What i understood is 1- We have to enter the data from sheet1 to sheet2 2-"Bernjena" is the next food that needs to filled in Sheet2 (as per the requirements) Більше
I can do the job. I have lot of experience with excel(you can see previous comments). I can start working on this right now. (I am from Aiken, South Carolina)
i can do it, i have seen your excel sheet1 and 2 , so i can do this as your instruction.......... you can discuss me too or award it...
Hi I am ready to start immediate. I can do the job. let start. I am talent data entry worker. you can contact me soon.