Cleaning up some excel spreadsheets

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