I need an Excel spreadsheet of client contact information cleaned up using a few simple rules. I am confident that I did not anticipate all scenarios, and it will require a bit of back and forth to complete.
There are two tabs in the attached file. The first tab needs to be converted into the second tab. I have several rows of examples in the second tab (New Client Data) to get you started.
Please begin with only the first 120 or so rows so that I can review and verify that we are on the right track.
1) For duplicate Business Name, First Name, Last Name, Phone, Email, put the duplicate inside the same cell
2) For duplicate addresses, add a new row to store the new addresses.
32 фрилансеров(-а) в среднем готовы выполнить эту работу за $116
Hi, I can clean up Excel Spreadsheet. Hi, I can clean up Excel Spreadsheet. Hi, I can clean up Excel Spreadsheet. Hi, I can clean up Excel Spreadsheet.
Hello, I am an Excel/VBA expert and I would like to help you clean up your spreadsheet. Please check my profile and contact me to discuss further details. Regards.
Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. Contact me to discuss the details. Best regards
Hi I would like to work with you. I am able to complete the work easily.i can start work now If you are interested. Please contact me. Thank you
Hey, sure. I would like to work on few clean ups before as a sample. Message me, I will be able to start soon. Duplicates for 1 should be put in the same cell and duplicates for 2 in a new row.
Hi there! I''m experienced and skilled in MS Excel, having used this application extensively to manage a large educational institution. I'll be able to clean up your client data as you require. Karen
Hi, i saw your project and i will be with accuracy and qualite. I can do this fast! Please send me a message and will be discuss more about your project.