This task involves cleaning up 10 attached CSV spreadsheets (in attached zipfile) and then combining the cleaned up CSVs into a single CSV
Step 1: Delete rows in each of the 10 spreadsheets in which columns A through AA are ALL Blank (if ANY cell in range A - AA contains a value do not delete the row)
Step 2: Save each of the files individually as current filename underscore NoEmptyRows.
Step 3: Zip or rar the files into a single zip or rar titled "FirstBatchINDIVIDUALFiles_NoEmptyRows" (dot zip or dot rar) and attach it to this project
Step 4: Take each of the edited individual files from Step 2/3 and where Column T, U, V, W, X, Y or Z are not null (not blank), BUT .. Column A IS blank, add the value of column A immediately above the currently blank A where Column T, U, V, W, X, Y or Z are not null (not blank). At the end of this exercise, EVERY row in which Column T, U, V, W, X, Y or Z that are not null (not blank) will have a value in column A. Not all will have values in columns B, C, D, E, F, G, H and I however. Just column A for the currently blank A sub rows.
Step 5: Save each of the files individually as current filename underscore NoEmptyRows underscore NoEmptyParcels.
Step 6: Zip or rar the files into a single zip or rar titled "FirstBatchINDIVIDUALFiles_NoEmptyRows_NoEmptyParcels" (dot zip or dot rar) and attach it to this project
Step 7: Take each of the individual files from step 5/6 and save them into one single file named "FirstBatchCOMBINEDFile_NoEmptyRows_NoEmptyParcels" and attach it to this project
The project will have 3 zip or rar files as attached deliverables:
1. "FirstBatchINDIVIDUALFiles_NoEmptyRows"
2. "FirstBatchINDIVIDUALFiles_NoEmptyRows_NoEmptyParcels"
3. "FirstBatchCOMBINEDFile_NoEmptyRows_NoEmptyParcels"
The winning bidder will be able to start work immediately and complete within a few hours. I guarantee top rating and positive feedback upon successful delivery.
Thank you
Dear Project Poster,
I have relevant hands on 5 years of experience . I assure you about the work quality and time delivery. Please give me chance to complete this project.
I had already done the same work in past. Looking forward to hear from you.
Let me give an opportunity to work. We can talk further when you message me.
Hello
I am highly interested to do your project.
I beleive that, I can do this work properly and in timely by your instruction.
Always determined to give you a best work.
Moreover, I have a group which consist of 5 members.
Thanks
Hi,
I am very interested to your excel cleaning up project. I have enough experience about all requirements to your project. I have highly confident that i can do your project quickly & accuracy. If you consider me for your projects, I will provide best quality service. I look forward to hearing from you.
Thanks & Regards,
Mehedi Hasan
I am very professional data entry and web researcher on freelancer.com. Here I completed a lot of project with good reputation. Very motivated, honest and hard worker. This is my main profession. So I take this seriously. Now I am trying to prove in here. Please give me an opportunity to doing this. Really appreciating a project here. I can start right now.
Hello there, how are you? I am very interested in doing this project and can start working on it after being awarded. Hoping to hear from you and may you have a great day ahead. Thank you :)
Hello,
My name is Virendra Meshram. Our potential to work and provide the best quality service requirements. I have lot of knowledge of this task. I can do this work very fast & I understood this project. I can start this project right now.
I have experience of Excel task, Admin Assistant, Data Entry, Amazon Listing, Copy - Paste Work, Google Research Trick , Email Research, Data Conversion & Article, Typing & Blog Posting. I am 100% sure that I can do this job very efficiently within your time-frame,
I can say that you will sure be happy working with us.
Please give a chance for this. Looking forward for a positive response. I am right person for this project.
Thanks and Regards,
Virendra Meshram
Hello..
I'm interested in the project you are offering. I am doing Excel as a free lancing. I am expert in Excel you just name it i will do that accordingly as per your instruction. I want to build my reputation here so I do the work to my best to get wonderful feedback and rating and that's what you are gonna get.
Give me a single chance to build a valuable relation with you. and perform your work like as its mine. Give me the project rest of work is mine.
Only in box me a single message i will be on my feet. anything can be negotiable.
Waiting for your extremely important message for me.
Things that I assure you are:
1) Turn out time
2) Quality
3) Availability
4) Straight Forward wordings
5) Creativity
And a lot more once we start this project.
Looking forward.
REGARDS
We have a team of 20 Excel spreadsheet expert who can handle any kind of complex excel scenario. We guarantee you to deliver work before prescribed time.