Hi,

I have 2 workbooks, In 1 workbook I have around 1000 names(entities) in column A and in the second workbook I have around 200 details in column A.

What I want is to copy & paste the 200 details entities to each of the 1000 names in the 1st workbook at column B. So the end result will have around 200,000 entities count.

Example:

Example1.jpg


End Result:

Example2.jpg


To manually do this for 1000x200 will take up a lot of time. Please suggest an easier way to perform this.

Thanks for the help.