Create a list with duplicate values

I have a list customers with their sales for 2010 and 2011. The 2010 information is above the 2011 info. So by cell this is how the rows look:
Row 1 says Customer A, 2010, the amount spent
Row 2 says Customer A, 2011, the amount spent
Row 3 says Customer B, 2010, the amount spent
Row 4 says Customer B, 2011, the amount spent

And so on. I have a seperate list that shows the sales rep for each customer. like this:
Customer A, Bob
Customer B, Ted

I want to add the sales rep names into the rows with the customer sales info.

Is there a way to automatically make:
Customer A, Bob
Customer B, Ted

duplicate like this:
Customer A, Bob
Customer A, Bob
Customer B, Ted
Customer B, Ted