Change excel data from one format into another

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)

Навички: Введення даних, Обробка даних, Excel

Деталі: excel change data format, data entry in spanish, list of spanish food, Spanish data entry, excel data sheet, food data, change column, names spanish, names change, spanish data, codes excel, excel spanish, pr0f3t, excel show format, show list excel, spanish names, food names spanish, excel add rows, sheet names excel, sheet format excel, quantities excel, excel horizontally vertically, uae data excel format, html format cut data excel spreadsheet web page, sheet sheet excel

Про роботодавця:
( 5 відгуки(-ів) ) United States, United States

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

$20 USD за 1 день
(11 відгуків(-и))

13 фрілансерів(-и) у середньому готові виконати цю роботу за $24


Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply. Lets start.

$30 USD за 0 дні(-в)
(139 відгуків(и))

Dear we have a team of 12 people that can handle your [login to view URL] have done many projects..we will follow according to your [login to view URL] only after the [login to view URL] will give you best result with limited [login to view URL] Більше

$34 USD за 3 дні(-в)
(21 відгуків(и))

Hello, I have done many similar jobs before, I can help you with this. 100% accuracy. Thank you, Elvira

$20 USD за 1 день
(31 відгуків(и))

Hello,i can do this for you,and can start right,check my reviews to see it will all work fine. Regards, Bojan

$25 USD за 1 день
(19 відгуків(и))

Hello there. I have high Excel and Visual Basic skills with great professionalism. I study electronics and computer engineering at Oporto university and I'm looking for work to fill the blanks on my schedule. I' Більше

$19 USD за 1 день
(18 відгуків(и))

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 Більше

$25 USD за 1 день
(7 відгуків(и))

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) Більше

$25 USD за 1 день
(10 відгуків(и))

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)

$25 USD за 3 дні(-в)
(2 відгуків(и))

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...

$15 USD за 2 дні(-в)
(1 відгук)

I've just created my account on freelancer and i'm still learning the process, but i want to tell you that i have excellent computer skills, i have a professional degree in English, i've graduated from 2 universities(F Більше

$25 USD за 1 день
(0 відгуків(и))

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.

$25 USD за 3 дні(-в)
(0 відгуків(и))

Esteemed Sir. I can make this task in a short time. I have vast experience with Microsoft Excel and your project could be done in 1/2 day or less. Feel free to talk about of your project with me, sure that I can help y Більше

$25 USD за 3 дні(-в)
(0 відгуків(и))