I have 120 variables that I need to write all possible combi

I have 1-20 variables that I need to write all possible combinations in Excel. I use the combin funtion & run this function 20 times. This gives me combin(20,1), combin(20,2), combin(20,3) & so on until combin(20,20). The total comes to 1,048,575 possible combinations. Pls advise how to write all these, I assume there is a technique similar to writing permutations. This would be 20 columns & 1,048,575 rows.

Solution

THe command you use is perfect. I write this in a excel format