Combining values from two different columns

How can I combine values in two different columns where the first value in the first column is combined with all other values in the second column, then the second value in the first column is combined with all other values in the second column, etc.?
I usually do this manually but I wonder if there a macro or function in Excel that can do this automatically.
Thanks,

GL #
6101
6102
6203


Dept
10001
10002
10003
10004
10005
10006


Combinations
6101 10001
6101 10002
6101 10003
6101 10004
6101 10005
6101 10006
6102 10001
6102 10002
6102 10003
6102 10004
6102 10005
6203 10001
6203 10002
6203 10003
6203 10004
6203 10005
6203 10006

Hi

Assuming that your GLs are in column A, starting in row 2, and the Depts are in column B, starting in row 2 then try

Please Login or Register  to view this content.

rylo

Thanks rylo. That works perfectly!