Hi, here is my problem, simplified:
Table1:
Alabama
Alaska
Arizona
Arkansas
California
Colorado
Connecticut
Delaware
Florida
Georgia
Table2:
red
white
blue
I want to join the two tables such that the join loops through Table2 and connects its values to Table1 until Table1 is finished, so the end result will look like this:
Joined Table:
Column1 Column2
Alabama red
Alaska white
Arizona blue
Arkansas red
California white
Colorado blue
Connecticut red
Delaware white
Florida blue
Georgia red
How do I do this?
Solved! Go to Solution.
That worked perfectly. Thanks for the quick solution!