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 Pink Blue Brown
Yellow Pink Blue Brown
Yellow Pink Blue Black
Yellow Pink Brown Black
ect..