I am just beginning to use excel and am fairly ingnorant about databases and computers, in general. I would appreciate it if someone could tell me if the following calculation can be done and, if so, how.
If I have a meat column with
Beef
Chicken
Fish
and a veggie column with
Broccoli
Green Beans
Carrots
Is there a formula I can use that will list all the possible combinations of the items in the columns using only one item from each list?
I want the results to look something like this:
Beef Broccoli
Beef Green Beans
Beef Carrots
Chicken Broccoli
Chicken Green Beans
Chicken Carrots
Fish Broccoli
Fish Green Beans
Fish Carrots
Thanks,
JLB329
Bookmarks