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.