How do I paste/insert a list into another list

[MrSK]

Hi,

I have a list of customers like this:

Mr T.
Mr.S
Mr. A
Mr. D
etc...

I want to insert a list of products into each customer (ex. if I have 4 products I'd have 4 rows per customer)

Is there a way of doing this???

P.S. I have like 300 customers and 200 products per customer that I would need to do this for so it can't be something too manual....

Thanks

 

[Luke M]

Let's say your list of customers is in A1:A300, and products are in B1:B200. To make the formulas easier to read, we'll name those range custList and prodList


formula in C1 to list all customers
=INDEX(custList,INT((ROWS(C$1:C1)-1)/ROWS(prodList))+1)
formula in D1 to list all products:
=INDEX(prodList,MOD((ROWS(D$1:D1)-1),ROWS(prodList))+1)

Copy down as far as needed.

 

[MrSK]

You are actually so awesome thank you!!!