I am including two spreadsheets in the attached zip file. One is labeled "From". Another is labeled "To". I need a coder to write a script that auto-converts all of the data from all of the fields in the "From" spreadsheet to the data format and fields shown in the "To" spreadsheet. There are many worksheets within the "From" spreadsheet but only one worksheet in the "To" spreadsheet that shows the format required. Also, the data shown in the attached "From" spreadsheet is only about 10% of the data that needs to be converted. I have provided it as a sample because I don't want to show all of the data in a public bid. But it is a good enough sample that should allow you to write a robust script.
Please make sure that all of the converted data should not contain any invalid character, should not have more than single spaces and should not contain the character "\".
Once I award the project the coder will be required to show me the results for the first worksheet so that I can suggest changes for the others.
See attached files for excel spreadsheets mentioned in the project description.