I have a database of insurance companies. Each record (row) has multiple insurance companies separated by a comma. I need a standardized database where each unique insurance company name occupies a single row. I had a colleague who created a quick macro that scans through records like this and builds a unique table. I lost the macro. Someone who is familiar with Excel can do this in 5 minutes. Attached is the Excel file. The first worksheet has the raw database. The second worksheet has the desired output, with the first 2 records parsed. If you have questions, you do not understand the project.
Greetings! It is an easy project and can be completed with desired results. We will use few Macro codes and formulas to create the sheet. Please reply to my bid for further discussion. Thanks Brad
10 freelancers are bidding on average $25 for this job
Hello, I was very interested in your project, so I decided to start it and It's already done, you just have to award me the project and I will send you the file. Best Regards, Roberto C.
You were absolutely right - it took all of about 5 minutes! You have 769 unique insurance agencies listed in your database. I have the macro and the updated file ready to send to you! Sincerely, ~Steven Good
Hi sir, Thank you for posting your job. I am very interested in the job. I will try my best to done the work before the deadlines. Hope to hear from you soon. Thank you. Best regrds, Nurul Hassnina