I have a table that looks like the following:
LETTERS -------- A B C D E F G H
I'd like to create a View that lists all the 3 letter combinations of these letters without repetition in the following way i.e. assigning a number to each combination.
ViewNew ------- 1 A 1 B 1 C 2 A 2 B 2 D 3 A 3 B 3 E
and so on.
Is the above possible? Any help will be much appreciated.