Vertical to Horizontal Data Special Conditions

**guypier** · 05-05-2011, 02:07 PM

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 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.

SKU 1
Image1
Image2
Image3
Image4
Image5
SKU 2
Image1
Image2
Image3
Image4
Image5
Image6
Image7
SKU 3
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

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

**StephenR** · 05-05-2011, 02:35 PM

Can you post a small sample workbook?

**JBeaucaire** · 05-05-2011, 02:38 PM

This should do it:

Please Login or Register  to view this content.

**guypier** · 05-05-2011, 02:49 PM

Here is a download to the file from my server http://www.pixeleightmedia.com/Data.xls

Thank You

**guypier** · 05-05-2011, 03:00 PM

**JBeaucaire** · 05-05-2011, 03:05 PM

First, please do not QUOTE my entire post, now the code that won't work is doubled in this thread. EDIT that post above and remove that, if you would...

Hehe.. Your post #1 indicated SKU was at the start of each string, but that wasn't true. Always start with a sample workbook, eliminates mistakes like that. Here's the redone code:

Please Login or Register  to view this content.

**guypier** · 05-05-2011, 03:25 PM

Ok fixed the quoted issue haha. Sorry about that. Ill try the code now.

**guypier** · 05-05-2011, 03:30 PM

Ok officially tested. And...

WORKS PERFECTLY... Thank you, you saved me a hell of a lot of time. I may have more things that will require macros ill be sure to ask you first.

Thanks again,
Guy Pierce