Create a Series of Rows of Repeating Values from Lists

[webfeet2]

Hello all,

I have an issue I was hoping someone could help me with. I have a series of lists, and I want to combine all of these lists so that there are a series of rows that repeat every value from each list.

For example, I have three columns for person, product, and date.

Person Product Date
John Product A April
Ken Product B May
Brenda Product C June

I want a quick way to create a series of rows that list every combination of these three lists. For example, for John I would need to end up with 9 rows to repeat every single product and every single month for this person.

John Product A April
John Product A May
John Product A June
John Product B April
John Product B May
John Product B June
John Product C April
John Product C May
John Product C June

Does anyone know of a macro or of a simple way to do this? The lists are quite long so doing it manually would be incredibly time consuming and prone to error.

I have attached an example workbook of the problem.