Excel data formatting

  • Posted:
  • Proposals: 3
  • Remote
  • #400940
  • Awarded
Boyd W.
Claire S.Ricky L. have already sent a proposal.
  • 0

Description

Experience Level: Intermediate
I have an Excel data cleaning job that I need some help with. I will outline the details below, if it sounds like something that you can help me with I will send you the data and further instructions to take a look at and quote for if that is okay?

The job requires data cleaning & codifying, but with a little bit of complexity. In short I need 2 lists of institutional names - with currently slightly different formatting - to be merged into one and given a unique numeric code for every time an individual institutional name appears against a separate city (I have columns of corresponding location data). The consolidated list will probably be approximately 12,000 rows. The names start the same way, but finish differently - ie XYZ Management LLC vs XYZ Mgt, etc.

I also have 4 short lists of institutions which need to have their new unique numeric ID added, once these have been created.

Thats it... does it sound like something that you'd be able to help me with?

Thanks a lot,

Charlie

New Proposal

Create an account now and send a proposal now to get this project.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.