Hey Guys,

Check out the below picture for reference.

Screen shot 2014-05-28 at 11.12.10 AM.png

What I want to do is this.

Columns A-E (Maximum of 5 individual words) create themes. Each row within column A-E is one theme. Eg. "Antique Seating Benches".

Column F contains theme additions. For each word in column F, I would like to create a formula that then creates a list somewhere else within the workbook that takes each column theme (between A-E) and multiplies (concantenate's) the theme by theme addition.

Eg.

Antique Seating Benches
Antique Seating Benches sale
Antique Seating Benches selection
Antique Seating Benches store
Antique Seating Benches buy
Antique Seating Benches purchase

In the picture example there are 31 rows, 28 with a theme and 6 theme modifiers including a blank space in column F. So a working formula would generate 168 individual words.

Any assistance is greatly appreciated! Let me know if you need any more information or further explanation.

Thanks!