Closed

Synchronize Rows in Excel - repost 3

I have 39 excel files, in each file, there are 4 columns with data , about 3500 rows. The first 2 columns are Date and Price, the second 2 are Date and Index.

I need someone to synchronize the files, so that the dates are the same with the numbers for price and index. Now some of the cells are empty, or with *, or sometimes there is Index info but no Price info. I want only rows where there is both Index and Price. The other should be deleted. All data must be accurate as its now. Only manipulation should be done, so rows where Index or Price doesn't exist, to be removed. I also need report on which rows were deleted for each of the files (with the row info before that).

I will double check the files to make sure it all fits. I attach here example file.

Only the Tables with- "True" in the name, should be manipulated.

Don't bid if you don't understand 100%, what's the task. Message me if you have questions.

Skills: Copy Typing, Data Entry, Data Processing, Excel, Word

See more: synchronize rows excel repost, double data entry excel, synchronize, rows, excel synchronize rows, synchronize rows excel, check data excel files, check excel files, excel check double, check data entry report, excel file data manipulation, index excel, synchronize file, report check data entry, excel rows, excel manipulation, check report data entry, price file excel, data report excel, data entry true, collection excel rows, excel row columns, paste excel rows project, rows excel, tables excel

About the Employer:
( 0 reviews ) India

Project ID: #5110739

45 freelancers are bidding on average $25 for this job

harubel

Take the service from the expert. I read out your project details and confidently bid here to work on it. Please share your file with me. I will provide you a sample work first and then expect the project if you More

$35 USD in 3 days
(33 Reviews)
5.7
MRDzA

PLEASE, CONTACT US FOR MORE DETAILS -------- www.vzstudio.me ------- Dear Sir/Madam, I am offerring you our services. You will have unlimited revisions and guaranteed quality as result. If you are not sattisfied with More

$35 USD in 5 days
(1 Review)
3.4
Aldo21

Easy job, ive done similar to other employer. download all this files in same folder and open mastersheet, then play with the import buttons to see mergin results https://drive.google.com/file/d/0B5LM-dF66NaoUjk3eFZ More

$20 USD in 3 days
(8 Reviews)
2.9
wishr

A data processing expert here. I can do it for you with accuracy and perfection. Please upload the sample file. I cant find it.

$35 USD in 10 days
(5 Reviews)
2.7
revolancer

Hello, I understand the project, and could start ASAP. Send me the files. Thanks Regards Skype:saba.siraj

$25 USD in 0 days
(4 Reviews)
2.6
alicja1234

Hello,I can start right now. I would like only to see 1 doc.What kind of fond do you prefer etc. I work fast and I am concentrated on details . You can rely on my work. Please see my portfolio. Best regards Alicja

$24 USD in 3 days
(1 Review)
2.1
rrangawat

Hi, I’m interested in your project Good day! After reading the project description, I’m confident that I can do this job on time with 100% accuracy. I hope you will consider me for this job and i can start immediat More

$25 USD in 3 days
(5 Reviews)
2.0
Muhammad78608

Ready to start. Please give me a chance. I would try to complete the project with accuracy. I assure you that you would not be disappointed with my work. Thanks.

$30 USD in 7 days
(1 Review)
0.2
ashuasghar11

A proposal has not yet been provided

$25 USD in 3 days
(0 Reviews)
0.0
hi2shiva

I am Data Analyst with 6 years of experience .Can deliver the project with quality on time . Currently working on the similar kind of project. Software Tools MS. Office Quotation for the proposed project S More

$15 USD in 3 days
(0 Reviews)
0.0
athalyeabhay

I am available and can start immediately. I am experienced, will stick to schedules, and generally a perfectionist. II am quick learner and will be able to handle job on my own.

$35 USD in 3 days
(0 Reviews)
0.0
shahanashihab

Hi, if you will give me a sample, I assure you that I will finish your work with the desired accuracy within the desired time. Looking forward to hearing from you.

$25 USD in 3 days
(0 Reviews)
0.0
FrostyTheSnowMan

Propunerea nu a fost încă furnizată

$10 USD in 1 day
(0 Reviews)
0.0
azrinbintiaris

excel is 1 if my skills. this work will done in 2 days time as it just a simple task. with the price and time i bid for, will result good outcome as per request.

$25 USD in 2 days
(0 Reviews)
0.0
anigre

A proposal has not yet been provided

$25 USD in 3 days
(0 Reviews)
0.0
martapf

La propuesta todavía no ha sido proveída

$25 USD in 32 days
(0 Reviews)
0.0
ENRICOJ

HI SIR.IM SO EXICTED TO HAVE JOIN THIS AWSOME SITE.AFTER LOOKING AT YOUR PROJECT AND DOWNLOADING YOUR SAMPLE FILE I START WORKING ON IT IMMEDIATELY.AM HAPPY TO SAY AFTER SPENDING A FEW HOURS I MANAGE TO AUTOMATE THE PR More

$30 USD in 1 day
(0 Reviews)
0.0
obbialikhan

I have seen the link you provided in description and I feel myself fully confident to do your work. I assure you my maximum dedication for your work. I have almost more than 5 years working experience in MS Office. M More

$25 USD in 2 days
(0 Reviews)
0.0
Madrohinam

As this is excel project, can be done in the time line put in the bid

$23 USD in 4 days
(0 Reviews)
0.0
hotcold85

A proposal has not yet been provided

$25 USD in 3 days
(0 Reviews)
0.0