Creating a Function for generating PPC Phrases

[samstewartblake]

Hello

My macbook recently crashed, and I recently lost one of my most valuable excel functions..I can't figure out how to re-write the function which organizes the data into the fashion that I desire.

FYI: I dabble in Pay Per Click advertising, so the following function will be used to generate phrases for google adwords with greater efficiency.


First, I will give an example of data, second, I will give an example of the output I desire

The following data is data that could be used to create phrases for targeting customers who want to buy ice cream:

EXAMPLE:

Column A Column B Column C

Row 1 Buy Ice Cream Locally
Row 2 Purchase Frozen Yogurt In Philadelphia
Row 3 Best Deals On Cold Desserts Downtown



Ideally, the goal would be to return every combination of phrase that is ordered in the following manner: Column A, Column B, Column C

The ideal output for the above example would be the following:

EXAMPLE OUTPUT:

Buy Ice Cream Locally
Buy Ice Cream In Philadelphia
Buy Ice Cream Downtown
Buy Frozen Yogurt Locally
Buy Frozen Yogurt In Philadelphia
Buy Frozen Yogurt Downtown
Buy Cold Desserts Locally
Buy Cold Desserts In Philadelphia
Buy Cold Desserts Downtown
Purchase Ice Cream Locally
Purchase Ice Cream In Philadelphia
Purchase Ice Cream Downtown
Purchase Frozen Yogurt Locally
Purchase Frozen Yogurt In Philadelphia
Purchase Frozen Yogurt Downtown
Purchase Cold Desserts Locally
Purchase Cold Desserts In Philadelphia
Purchase Cold Desserts Downtown
Best Deals On Ice Cream Locally
Best Deals On Ice Cream In Philadelphia
Best Deals On Ice Cream Downtown
Best Deals On Frozen Yogurt Locally
Best Deals On Frozen Yogurt In Philadelphia
Best Deals On Frozen Yogurt Downtown
Best Deals On Cold Desserts Locally
Best Deals On Cold Desserts In Philadelphia
Best Deals On Cold Desserts Downtown


This is a more simple example, and most phrases I intend to create will have 5-6 columns and 10-20 rows, obviously with a much larger data output, making it nearly impossible to write out every combination as I had done above.

Please, help provide me with the simple function that will output data as shown above.

I am sure if I have a simple function such as this, I would be able to manually change the parameters of the function to suit my needs of extra rows/columns when needed.

Thanks in advance for your help!

Cheers,

Sam B.

[GC Excel]

Hi,

Just found this code on Google...
http://stackoverflow.com/questions/1...ion-of-a-range

Please Login or Register  to view this content.

[samstewartblake]

Wow, thank you very much.

It actually works, you really saved the day my friend.

Let me ask, how did you find that on google? I searched forever!

Thanks Again!

Sam

[shg]

There's a workbook that will do this at https://app.box.com/s/47b28f19d794b25511be