Sorting images to the respective SKU

[mifzal.mufthi]

I have a list of products in a Master file and I want to fill only the following on another worksheet

title
description
image1
image2
image3
item_specifics (SKU)

Please note that each SKU will have more than 1 image(s). I want to put the 1st image of that respective SKU to image1 and 2nd image of that respective SKU to image2 and 3rd image of that respective SKU to image3. After filling the 1st 3 images, automatically the file should pick the 2nd SKU in the Master file to repeat the same process for the 2nd SKU.

Please help me to fix this.

[mifzal.mufthi]

Anyone out there please?

[mifzal.mufthi]

Hello... Nobody is here? Please help me

[FlameRetired]

This is a challenging puzzle.

Additionally response may be a bit slow for a few days.

If you are not aware of it the United States is approaching a major holiday.

Of course while not every contributor is American it may have a noticeable affect.


Before attempting a solution I have a few questions.

1. I assume the "title" is in column D?
2. If there is no "description" what do you want returned in the second row of each set?
   

   Please note that each SKU will have more than 1 image(s). I want to put the 1st image of that respective SKU to image1 and 2nd image of that respective SKU to image2 and 3rd image of that respective SKU to image3. After filling the 1st 3 images, automatically the file should pick the 2nd SKU ...

3. Do you want to return all of the numbered jpgs in each set or just the first 3?
4. Are there any additional criteria?
5. Is there any additional output you'll want?

[mifzal.mufthi]

This is a challenging puzzle.

Additionally response may be a bit slow for a few days.

If you are not aware of it the United States is approaching a major holiday.

Of course while not every contributor is American it may have a noticeable affect.


Before attempting a solution I have a few questions.

1. I assume the "title" is in column D? - Yes
2. If there is no "description" what do you want returned in the second row of each set?
   
3. Do you want to return all of the numbered jpgs in each set or just the first 3? - Just the first 3 or even any 3 pictures are fine
4. Are there any additional criteria? - I have mentioned everything below
5. Is there any additional output you'll want? - I have mentioned everything below

Firstly, I thank you for responding to my query and appreciate your support. Secondly, I have forgotten to upload the

required Excel sheet to be filled. I have uploaded only the Master sheet but not "bulk_upload_sample.xlsx". Please refer

the Excel sheet which needs to be filled and it's name is "bulk_upload_sample.xlsx"

I want to fill only the column B, F, J, K, L & M in "bulk_upload_sample.xlsx"

[FlameRetired]

Does it have to be separate workbooks. ie can I just copy the sheet with the data and paste in a new sheet of bulk_upload?

[mifzal.mufthi]

Does it have to be separate workbooks. ie can I just copy the sheet with the data and paste in a new sheet of bulk_upload?

I want with forumulas not just the answer so that I can do on my own for other products. If you want, you can do this. Prepare 1 Excel file. In that, you can have Master sheet with all the data I have uploaded and formula sheet with filled columns

[FlameRetired]

I consolidated by inserting a Master sheet with the original source data in it.

In M2 of 'bulk_upload_sample' array enter this formula and fill down until you get blanks. It returns the unique skus. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

=IFERROR(INDEX(Master!$A$2:$A$81,SMALL(IF(FREQUENCY(MATCH(Master!$A$2:$A$81,Master!$A$2:$A$81,0),

ROW($A$2:$A$81)-MIN(ROW($A$2:$A$81))+1),ROW($A$2:$A$81)-MIN(ROW($A$2:$A$81))+1),ROWS($2:2))),"")

Then to return the image files array enter this in J2 fill down and across until you get blanks.

=IF($M2="","",INDEX(Master!$E$2:$E$81,MIN(IF(ISNUMBER(FIND(COLUMNS($J:J)&".",Master!$E$2:$E$81))*

ISNUMBER(FIND(".jpg",Master!$E$2:$E$81))*($M2=Master!$A$2:$A$81),ROW($A$2:$A$81)-MIN(ROW($A$2:$A$81))+1))))

In F2 this non array formula filled down until blanks. It returns the descriptions.

=IF($M2="","",INDEX(Master!$F$2:$F$81&"",MATCH(M2,Master!$A$2:$A$81,0)))

This non array entered in B2 and filled down returns the titles.

=IF($M2="","",INDEX(Master!$D$2:$D$81,MATCH(M2,Master!$A$2:$A$81,0)))