Duplicating ROWS

Hello everyone.

I have a CSV that I need to automate a certain functionality with.

Take a look at practica-fotos.csv and then practica-fotos-variation.csv (attached). These CSVs are for automating upload of products to an online store.

If you look closely I have the products listed in practica-fotos.csv but then I have product variations for each product in practica-fotos-variation.csv. I need practica-fotos-variation.csv to make 9 variations for each product in practica-fotos.csv. If you look at the CSV you will notice the variations are exactly the same for each product. The only thing I need to be unique to each product is the Image Name (e.g. "_DSC6859.jpg") and the Product Number, the rest is just the same for each product.

How do I automate this? I've tried everything and the only thing that would work is copy pasting each one... one by one... These two CSVs are just examples, I have over 200 products (in this case they are photographs) and more are coming quickly. I included 4 in these examples to not complicate it.

Could someone help me out with this? I don't know how to do this quickly and easily.

Thank you!!!

Sorry, I forgot to upload the attachments.

Ok, I think I figured out how to do it just now. I just something like this did this for Column A

1
1
=A1+1
=A2+1
=A3+1
=A4+1

Effectively always adding just what I need to add each time.

But I'd still need to find a way to duplicate each row 9 times to get the images names!

Well I solved it in a very primitive manner. I just duplicated the entire set of rows 9 times in the same column and then sorted A->Z so that it sorted them in sets of 9 in the order they were before.

Thanks anyway!!!! Hope this thread helps someone at least!

Hi,

Put both sheets into one workbook (keep the sheet names), then try this:

Please Login or Register  to view this content.

Let me know if you need help using it.

CC