I have two columns
Column A which has letters A, B, C until Z
Column B which has letters 1, 2, 3 until 9
I would like a macro to return the combination of every cell in Column A with every cell in column B in column C
i.e. it should return in Column C, A 1, A 2, A 3 until A 9 and then B 1, B 2 until B 9 until Z 9.
Thanks for the help.