Programmer for list cleaning
Budget: $30 – $100 USD
I have a spreadsheet with 5270 rows. The cells have single names or a series of names in one cell. I estimate there are about 6800 names in the cells. I need the names extracted into two products below.
Product #1: Preserve the exact number of rows and keep names on their original rows, placing one whole/full name in each cell. Multiple names will occupy multiple cells in a single row. The product must remain in Excel.
Product #2: Create a new file such that there are no commas in the cells, and arranged so that first name and last name are in separate cells. The number of rows will increase, as there should only be one name per row. The product can be an Excel or CSV file.
You would need to disclose your process whether automated or tediously manual, as well as the proposed manner and number of spot checks to ensure quality and accuracy.
Product #1: Preserve the exact number of rows and keep names on their original rows, placing one whole/full name in each cell. Multiple names will occupy multiple cells in a single row. The product must remain in Excel.
Product #2: Create a new file such that there are no commas in the cells, and arranged so that first name and last name are in separate cells. The number of rows will increase, as there should only be one name per row. The product can be an Excel or CSV file.
You would need to disclose your process whether automated or tediously manual, as well as the proposed manner and number of spot checks to ensure quality and accuracy.