Cleaning up some excel spreadsheets
$10-30 USD
ชำระเงินเมื่อจัดส่ง
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
หมายเลขโปรเจค: #11142371
เกี่ยวกับโปรเจกต์
freelancer 22 คน กำลังเสนอราคาในงานนี้ โดยมีราคาเฉลี่ยอยู่ที่ $27
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 pas เพิ่มเติม
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 เพิ่มเติม
hi can start clearing it right now and can provide consolidated information within few hours. looking forward to win the bid. Thanks
Hello, I have reviewed the excel csv and your requirements, I am available to start the job right now. Please consider my bid. Regards,
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 star เพิ่มเติม
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 her เพิ่มเติม
Dear Sir/Madam, I want to work for you on this project. Please contact me for more details and further process, Thanks
Hello! I have a great experience in Excel and Visual Basic for Excel, so I can complete your project in short time. 100% errors free!
I am the best candidate for the position because I have all the knowledge and skill for the said position and I can give justice to the job
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.