I have some company information which I require to be formatted into a specific format. The text has been extracted from a PDF file. There are approximately business 600 records.
In the attached spreadsheet you will see rows 4,6&7 which is the required record format. Below this you will see the raw data for 2 additional records. Rows 10-22 make up the data for 1 new record and rows 44-65 another record.
I will supply the full file (with all records to the successful bidder).
You can either work within the MS Excel file or use the dbf file (both contain the same data). I have supplied the dbf file as it may be easier to extract the required data in correct format and then do minimal manual updating/corrections of the data. I am looking for the result which is the records formatted as per rows 4,5& 6 in the spreadsheet so I do not mind which approach you take as long as I get an MS Excel file containing all accurate records in the correct format.
I am happy to close this project early and get started immediately if someone can demostrate that they can do this quickly.
I also have a second file approximately 1.5 times this initial file size (922 records) that I will require the same formatting done. I will list this as a seperate project and would be happy to give the work to the same person if they complete the initial task quickly, accurately and to my requirements.
## Deliverables
1) MS Excel file containg all records, 100% accurate in format advised (ie. rows 4,5&6 in supplied spreadsheet).
2) All data will remain my property and cannot be shared with anyone else.
3) Delete all files from your system once the project is completed to my satisfaction.
4) Ideally I require the initial file completed within 24 hours.
## Platform
MS Excel
DBF