Transpose column while matching to a lookup value

[BMo1982]

I have a list of item #s (skus) with a list of corresponding image names. Currently, my list of skus is a column format, as is the list of matching image names. I need the image names to all appear in the same row as the sku #. The issue is, not every sku has an equal amount of corresponding images. I cannot figure out how to bring the image names up to the row in the event of more than one available image. I tried to draw a picture to explain what I'm trying to do. The red 'X' shows the destination that I'm trying to get the image names to.

 

[BMo1982]

I have a list of item #s (skus) with a list of corresponding image names. Currently, my list of skus is a column format, as is the list of matching image names. I need the image names to all appear in the same row as the sku #. The issue is, not every sku has an equal amount of corresponding images. I cannot figure out how to bring the image names up to the row in the event of more than one available image. I tried to draw a picture to explain what I'm trying to do. The red 'X' shows the destination that I'm trying to get the image names to.

I should add that I have about 650 items that I'm trying to match so anything manual is out of the question...

 

[alansidman]

Cannot manipulate data in a picture. Please reload your sample using XL2BB and also provide a mocked up solution.