Combine data from two excel files

  • Posted:
  • Proposals: 12
  • Remote
  • #666975
  • Awarded
Viktor K.
Sunanda S.David H.Kumail R.Russell M. + 7 others have already sent a proposal.
  • 4

Description

Experience Level: Entry
Here is what I am seeking: There are two files that need their data combined in the format I want (File 1 + 2). There is a unique identifier for each applicant (license number). If you use it to pull information in File 1 to categorize it under their "Operator", then I can have the info I want.

I have attached both reports. As you can see on the EstablishmentLinkTO, there are some that are not operational (N/A). I have made an example excel sheet of the info I am seeking. I would like the formulas and brief instructions so I can recreate this myself.

New Proposal

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

Sign up

Clarification Board Ask a Question

    There are no clarification messages.