Hi all:
I actually have a quick question for you:
Step 1: I have two set of data (2 excel files). First set (excel file) contained vendor name and amount paid for each vendor (in total the first set has around 1000 rows).
Step 2: The second set (excel file) has only the vendor names (around 50 vendors).
the end goal is to create a unique excel file that has ALL 50 vendor names in step 2 AND include the total amount paid for each vendors noted in step 1.
Can I use the join tool to do the exercise?
Appreciate any workflow you could provide.
Cheers,
