Excel - Multiply text and sort in one column
<p>I work with multiple keywords and target local cities in a county.  Many times I will be targeting 50 - 100 keywords for 20-50 cities.  I need these keywords listed a certain way.</p>

<p>For example:  If I have 5 keywords targeting 5 cities, I would need a list of 25 total keywords in one excel column. It just depends on my project how many keywords I will be using and how many cities I will target.</p>

<p>So if I have a list of:</p>

<pre><code>keyword1
keyword2
keyword3
keyword4    
keyword5
</code></pre>

<p>Since I would be targeting 5 cities, each keyword would need to be multiplied by 5.</p>

<p>Need to be able to add that list to excel and have it create a list like this I can copy out:</p>

<pre><code>keyword1    
keyword1    
keyword1    
keyword1    
keyword1    
keyword2    
keyword2    
keyword2    
keyword2    
keyword2    
keyword3    
keyword3    
keyword3    
keyword3    
keyword3    
keyword4    
keyword4   
keyword4    
keyword4    
keyword4    
keyword5    
keyword5    
keyword5    
keyword5    
keyword5
</code></pre>

<p>Any thoughts?  Thanks for the help!</p>