Completed

Super Simple Database Parse Query

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.

Skills: Data Processing, Database Programming, Excel

See more: simple access database search query, database project purchases table, database error query table phplist, parse relation query javascript, parse server query, parse data storage, parse javascript sdk, parse android, parse api, parse sdk, parse query android, data processing, excel, database programming, visual basic for apps, database error query table, simple database replication project, simple database project documentation, parse text delimited file mysql database, database query project access

About the Employer:
( 55 reviews ) Los Gatos, United States

Project ID: #16978347

Awarded to:

Dhruvika111

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

$19 USD in 1 day
(316 Reviews)
7.6

10 freelancers are bidding on average $25 for this job

mirniyazuddin92

Dear Sir/Ma'am, I can do database parse query. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir

$30 USD in 1 day
(340 Reviews)
7.9
KulfiSoftwares

I love excel automation I have checked your attachment.. Please go ahead and award me the project, and I can send you the file as soon as possible. ZERO ERROR GUARANTEED!! Please read my 350+ reviews. I am here to More

$30 USD in 0 days
(286 Reviews)
7.5
mtdevil369

good morning , i like your project.I am a highly trained in Data Entry, Research, Web search, Web scrape, great knowledge of Excel and all Social Networks. My bid is optional and I will let you chose the price that sui More

$25 USD in 1 day
(154 Reviews)
6.2
avidusman

Hello, I have seen the Unique-Insurance-Companies file and fully understand your requirement. I can build a macro for the desired result very efficiently. I am a professional having good expertise in Excel with e More

$26 USD in 1 day
(12 Reviews)
3.9
Altantsetseg

Hello, From your project declaration, its the kind of job I have been experienced well. I am experienced in programming including MS Office since 2000. During 2007-2012, i'd been working as a senior developer for t More

$35 USD in 1 day
(5 Reviews)
3.7
robcastillo

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.

$20 USD in 0 days
(15 Reviews)
3.5
$10 USD in 1 day
(0 Reviews)
0.0
stevengoodboy

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

$25 USD in 0 days
(0 Reviews)
0.0
nurulhasninaa

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

$30 USD in 5 days
(0 Reviews)
0.0