Pull in all three files using a wild card, add a unique record identifier, and update field names.

$2.$ Pull $$Source$$ values into their own field and fill. $($Source example $3692$ US$-$ Mock USA$)$

$3.$ Pull $$Category Numbers$$ into their own field and fill. $(8$ digit values$)$

$4.$ Pull $$Categories$$ values into their own field and fill. $($Always provided on the same record as a

category number$)$

$5.$ Replace # with $9999$ and pull $$Partner Numbers$$ into their own field. Remove records without a

partner number, then remove and reorganize fields.

Deliverables: