Thread: I am looking for Help with inserting data with a CSV File

I am working on a ver large CSV File.

This file is used to upload to my website to instruct the site where to find the images for a product.

Here is a small sample of the CSV file and there will be more details below the sample:

imageProduct imageSrc imageType imageNumber
KL1001 prodimages/XXXXX_small.jpg 0 0
KL1001 prodimages/XXXXX_medium.jpg 1 0
KL1001 prodimages/XXXXX.jpg 2 0
KL1002 prodimages/XXXXX_small.jpg 0 0
KL1002 prodimages/XXXXX_medium.jpg 1 0
KL1002 prodimages/XXXXX.jpg 2 0

There are over 22,000 entries on this CSV file. In Column A this is the product number, my images also use product number as the name of the image.

Column B states the directory is prodimages/ and where XXXXX is is where I need to insert the product number from column a i.e. in the first line I need column b to look like this prodimages/KL1001_small.jpg and then the next like to look like this prodimages/KL1001_medium.jpg and then the third row to look like this prodimages/KL1001.jpg

The reason a single product (KL1001) has three lines in the CSV file is to tell the website (KL1001_small.jpg) is the image that is sized at 150x150 pixels and (KL1001_medium.jpg) is size 350x350 Pixels and finally (KL1001.jpg) is the 800x800 pixel size.

So basically I am seeking help to see if some one can explain to me How I could get excel to populate this data for me.

Thanks
Alan

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST