Hi I am not sure if this is a function that Excel can help with at all so hoping some genius can help out.

I have one jpg image named SECONDARYIMAGE3 that I need to duplicate across hundreds of items to show the same "secondary information image" across a range of products.

I have a list of the product codes on an excel spreadsheet in column A along with the required image name in column B - each code is unique (couple of examples below)
CODE IMAGE CODE
B03MVJDJY2 B03MVJDJY2.SECONDARY.jpg
B02SUYDJY1 B02SUYDJY1.SECONDARY.jpg

Is there any formula I can use to transfer the product code name from Column B and duplicate multiple times to the one image I have to show the new image code names?

I am guessing there isnt an easy way to do this but if I cant find a way I am going to have to copy and paste each unique name into an image folder containing hundreds of duplicate copies of the same image.

Any ideas/suggestions would be greatly appreciated.