Creating Lists

[djreason]

I am not that proficient in Excel, but I would like to know if there is a way to perform a function or program/macro that will allow me to create a robust list of text variables quickly.

For example:

In column A, I have "word 1, word 2, word 3, word 4, word 5" in cells A1-A5 respectively.

In Column B, I have "word a, word b, word c, word d, word e" in cells B1-B5 respectively.

I need the final list to combine "word 1" with "word a, word b, word c, word d, word e" for the final output of "word 1 word a, word 1 word b, word 1 word c, word 1 word d, word 1 word e" and so on down the list until all possible combinations of words are accounted for and present.

This is in an effort to quickly and efficiently create keyword combinations for an online PPC program that has over 470 campaigns, 2800 ad groups. So, manual creation of keyword variations is just not efficient or an option.

PLEASE HELP!!

[shg]

See attached.