I am using some data scraping software to get all the image urls from the site so I can use them in my other database. Here is the problem the data is coming in vertically and I need it horizontally "well use transpose" yes works but I also need to DeDup and there are about 53,000 images and do not want to go through it one line at a time. I would like to use a macro for this. Here is what I have and what I need the finished product to look like.


Column 1
SKU 1
SKU 1
SKU 1
SKU 1
SKU 1
Column 2
Image1
Image2
Image3
Image4
Image5
Column 1
SKU 2
SKU 2
SKU 2
SKU 2
SKU 2
SKU 2
SKU 2
Column 2
Image1
Image2
Image3
Image4
Image5
Image6
Image7
Column 1
SKU 3
SKU 3
Column 2
Image1
Image2


Needs to be like this:

SKU 1 | Image1 | Image2 | Image3 | Image4| Image5
SKU 2 | Image1 | Image2 | Image3 | Image4 | Image5 | Image6 | Image7
SKU 3 | Image1 | Image2


So the Sku will need to be DeDuped and all images for that sku transposed to that sku
The number of images change any where from 1 - 19 images per sku.

I hope I explained this well enough!
Any help would be much appreciated.

Thanks,
Guy