# Concatenate 2 Columns To Make Every Possible Combination

Jul 19, 2009Is there an easy way to concatenate two columns and provide every possible combination?

E.g.,

A B

1 A1 B1

2 A2 B2

3 A3

The function should result in

C

1 A1B1

2 A1B2

3 A2B1

4 A2B2

5 A3B1

6 A3B2