Display all combinations from a set of numbers

Hi

I have a simple question I think, just not sure how to go about it.

Let's say I have a row of numbers:

1 2 3 4 5 6 7 8 9 10 11 12 13 14

and let's say I want to display on the spreadsheet all the possible combinations of 2 numbers:

1-2, 1-3, 1-4, etc

OR let's say I want to see all the possible combinations of 3 numbers:

1-2-3, 1-2-4, 1-2-5, etc


I have done this manually, but I am guessing there is a better way.


Also

Let's say I have 6 sets 5 numbers:

10 12 13 17 18 19
27 28 29 10 11 12
30 31 32 33 34 35
40 41 42 43 44 45
50 51 52 53 54 55


What sort of function can I use to show all the possible combinations, where
each number stays in its own column?

For example, the first combination of 6 would be:

10 12 13 17 18 19

then

10 28 13 17 18 19

then

10 31 13 17 18 19

etc, where the 10, 27, 30, 40, 50 stay in column 1, the 12, 28, 31, 41, 51 stay in column 2, etc.





TIA!