Cleaning up some excel spreadsheets

กำลังดำเนินการ โพสต์แล้ว 7 ปีที่ผ่านมา ชำระเงินเมื่อจัดส่ง
กำลังดำเนินการ ชำระเงินเมื่อจัดส่ง

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

คีย์ข้อมูล การประมวลผลข้อมูล Excel

หมายเลขโปรเจค: #11142371

เกี่ยวกับโปรเจกต์

22 ข้อเสนอ โปรเจกต์ระยะไกล ใช้งาน %project.latestActivity_relativeTime|แทนที่%

freelancer 22 คน กำลังเสนอราคาในงานนี้ โดยมีราคาเฉลี่ยอยู่ที่ $27

schoudhary1553

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 เพิ่มเติม

$25 USD ใน 1 วัน
(233 รีวิว)
7.5
sadekhosen77

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 เพิ่มเติม

$25 USD ใน 1 วัน
(80 รีวิว)
6.4
tawakalgeek

hi can start clearing it right now and can provide consolidated information within few hours. looking forward to win the bid. Thanks

$55 USD ใน 0 วัน
(29 รีวิว)
6.1
mahfuz80

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 fo เพิ่มเติม

$25 USD ใน 1 วัน
(55 รีวิว)
6.2
nazmulcb

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 serious เพิ่มเติม

$30 USD ใน 1 วัน
(63 รีวิว)
5.9
kalidas365

Hello, I have reviewed the excel csv and your requirements, I am available to start the job right now. Please consider my bid. Regards,

$25 USD ใน 1 วัน
(153 รีวิว)
5.8
jennalynferanil

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

$30 USD ใน 1 วัน
(34 รีวิว)
5.9
Virend7586

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 เพิ่มเติม

$20 USD ใน 1 วัน
(17 รีวิว)
3.0
malikamjadhussai

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 เพิ่มเติม

$29 USD ใน 1 วัน
(5 รีวิว)
2.5
ShaheenIT

Dear Sir/Madam, I want to work for you on this project. Please contact me for more details and further process, Thanks

$30 USD ใน 0 วัน
(0 รีวิว)
0.0
ant4

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!

$30 USD ใน 0 วัน
(0 รีวิว)
0.0
willryan23

A proposal has not yet been provided

$25 USD ใน 1 วัน
(0 รีวิว)
0.0
aubbrey

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

$20 USD ใน 1 วัน
(1 รีวิว)
0.0
Bhadouriyaroshni

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.

$20 USD ใน 1 วัน
(0 รีวิว)
0.0
Dhananjay07

A proposal has not yet been provided

$17 USD ใน 2 วัน
(0 รีวิว)
0.0