Hello friends,

If I have a column of unique numbers in a spreadsheet, is it possible to use excel to generate every single possible pairing of different numbers from that selection of numbers?

For example if the numbers were

1
2
3
4

could I get excel to generate two columns that were

1 2
1 3
1 4
2 1
2 3
2 4
3 1
3 2
3 4

Have a feeling that I haven't explained that very clearly but hope someone can help...

Thank you.