jmmcintosh21
New Member
- Joined
- Apr 18, 2016
- Messages
- 1
So I have 4 columns in this table:
Color1 Color 2 Color 3 Color 4
Yellow Yellow Blue Blue
Pink Pink Brown Brown
White White Black Black
SO my goal is to create all possible combinations without having duplicates. I was thinking of using Cartesian join, but I'm not sure if that will work with multiple tables. Anyone have a way to do this without VBA?
End result looks something like this:
Yellow Blue Brown
Yellow Blue Brown
Yellow Blue Black
Yellow Brown Black
ect..
Color1 Color 2 Color 3 Color 4
Yellow Yellow Blue Blue
Pink Pink Brown Brown
White White Black Black
SO my goal is to create all possible combinations without having duplicates. I was thinking of using Cartesian join, but I'm not sure if that will work with multiple tables. Anyone have a way to do this without VBA?
End result looks something like this:
Yellow Blue Brown
Yellow Blue Brown
Yellow Blue Black
Yellow Brown Black
ect..