I'm looking for help with a solution to generate all possible combinations of a set of data, and have these combinations shown in separate columns.

Small example:

a | 1 | z | & | a | 1 | z | & | |

b | 2 | y | a | 1 | y | & | ||

c | x | a | 1 | x | & | |||

a | 2 | z | & | |||||

etc | etc | etc | etc | |||||

<tbody>

</tbody>

I will be working with larger datasets than in the above example, possibly generating 1-2000 combinations.

I am open to either a VBA or formula solution, but have very little experience with VBA so please provide some additional info rather than just code if possible.

Is it possible to do this?

Thanks