Database Filtering Help

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.

See the attached solution. I hope this is what you wanted, if not let me know...

Here it is with the assumption that rows 1-8 would have data in the original form... Let me know if this is what you meant.