Hey,

I Need VBA association script for 2 columns eg if in column a i have 2 values and in column b i have 3 values i would like to have an output like this:

column a

test
excel

column b

1
2
3

output

column a column b
test 1
test 2
test 3
excel 1
excel 2
excel 3

is this possible?

thanks in advance for any help!