Repeat Cells a certain number of times vertically

I have a list of stocks as shown here:

A UN Equity
AA UN Equity
AAPL UN Equity
....

I will create a new column that has the Date (a certain time period). Example:

18-04-2014
19-04-2014
20-04-2014
21-04-2014
22-04-2014

Now, how can I put the name of the stocks on the first column for each date. As shown here:


A UN Equity 18-04-2014
A UN Equity 19-04-2014
A UN Equity 20-04-2014
A UN Equity 21-04-2014
A UN Equity 22-04-2014
AA UN Equity 18-04-2014
AA UN Equity 19-04-2014
AA UN Equity 20-04-2014
AA UN Equity 21-04-2014
AA UN Equity 22-04-2014
AAPL UN Equity 18-04-2014
AAPL UN Equity 19-04-2014
AAPL UN Equity 20-04-2014
AAPL UN Equity 21-04-2014
AAPL UN Equity 22-04-2014
... ...

As you can imagine I don't have 3 stocks only, I have hundreds of them.

maybe see attached example?

Thanks for your help guys!


I solved the problem with ragulduy's suggestion on Book1.xls

It seemed simpler.