COnverting rows of products to columns

[SinksUS]

So I have an excel file with products led by the product code followed by image file locations...
Ex

001 C:\Users\Administrator\Documents\enclosure1.jpg C:\Users\Administrator\Documents\anotherimage.jpg etc.
002 C:\Users\Administrator\Documents\bath1.jpg C:\Users\Administrator\Documents\anotherimage2.jpg etc.
and what I need is to have these images in their own column followed or led by the product ID as such

001 C:\Users\Administrator\Documents\enclosure1.jpg
001 C:\Users\Administrator\Documents\anotherimage.jpg etc.
002 C:\Users\Administrator\Documents\bath1.jpg
002 C:\Users\Administrator\Documents\anotherimage2.jpg

and so on.

So far I have been doing each one manually but I have close to a thousand products with up to 11 pictures each and was wondering if anyone had any ideas...?

I could provide a sample in excel

Thanks in advance
Gilad

[Pete_UK]

Yes, provide a sample, and show what you want to achieve (a BEFORE and AFTER sheet, for example).

Pete

[apo]

Hi..

Assuming you have a space between each image filepath.. try this..

See attached file for demo..

Please Login or Register  to view this content.