Very specific question on tables
How can I assemble some non-repeating data?
Column 1 has 1,2,3,5,6,7,8
Column 2 has 1,2,4,6,7,8,9
Column 3 has 2,4,5,6,7,8,9
I would like to pull out a random value from each column, without repeats.
So, when I pull out values from column 2 and 3, and need to do some kind of filter on them to make sure the data I pulled out already does not match.
Can anyone point me in the right direction?