I have a Product Table with Code and Vendor.
I would like to know how I can in the vendor table list all the codes for a particular vendor.
Can I do this only through formulas in Excel?
Example below:
Good @lukkicode,
See if this solution suits your purpose.