I am in excel trying to pull a list of options for each product I have. For example -
Column A/Column B
Pants/Red
Pants/Blue
Pants/Green
Shorts/Orange
Shorts/Yellow
Shirt/Striped
Shirt/Polkadots
Shirt/Chevron
Shirt/Floral
What I would like is to be able to use my list of product names in...