Dear friends,
I have a database (attached herewith) which contains Product code, Pair type, Thumbnail, Detailed image, images.
If you look at product code, you will find the same product code for about 3-5 rows or more. In other words, each product code has about 3-5 images or more.
All what I want to know is, how to find those images of a particular product code and pair them according to this way.
I.E.
Product code : 86639
Pair type : M (1st image of the product should be M)
Thumbnail : 1st image of the product should be at Thumbnail cell
Detailed image : All additional images to corresponding to 86639 should be at Detailed image cell
Refer the highlighted cells to identify the requirement easily.
I can do this by filtering 1 by 1 but this is time consuming. If somebody can give me a hand, I really appreciate it.
Bookmarks