Synchronize Rows in Excel - repost 3

Avg Bid (USD)
Project Budget (USD)
$10 - $30

Project Description:
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 required:
Copy Typing, Data Entry, Data Processing, Excel, Word
About the employer:
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.

$ 35
in 3 days
$ 35
in 5 days
Hire Aldo21
$ 20
in 3 days
Hire wishr
$ 35
in 10 days
Hire revolancer
$ 25
in 0 days
$ 24
in 3 days
Hire rrangawat
$ 25
in 3 days
$ 30
in 7 days
Hire azrinbintiaris
$ 25
in 2 days
$ 15
in 3 days