Change excel data from one format into another

Completed Posted Oct 9, 2013 Paid on delivery
Completed Paid on delivery

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)

Data Entry Data Processing Excel

Project ID: #5011838

About the project

13 proposals Remote project Active Oct 9, 2013

Awarded to:

Solver86

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 in 1 day
(11 Reviews)
3.7

13 freelancers are bidding on average $24 for this job

Teloquence

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

$30 USD in 0 days
(139 Reviews)
6.3
for2nity

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

$20 USD in 1 day
(31 Reviews)
4.6
Saric123

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 in 1 day
(19 Reviews)
4.1
elMancha

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' More

$19 USD in 1 day
(18 Reviews)
4.0
SiroosJafary

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 More

$25 USD in 1 day
(7 Reviews)
3.4
customizedata

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) More

$25 USD in 1 day
(10 Reviews)
3.4
pachu11

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 in 3 days
(2 Reviews)
0.6
MaxTech3

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 in 2 days
(1 Review)
0.0
neacsu28

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 More

$25 USD in 1 day
(0 Reviews)
0.0
bappyrb

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 in 3 days
(0 Reviews)
0.0