Transpose a block of text

Hi All,

I'm hoping someone can point me in the right direction.

I have stumbled across Ron De Bruins website and have found exactly the sort of thing I need to automate the analysis of a large piece of activity based costing work I am about to embark on. It just needs one small tweak which is out of my league I am afraid.

I am using the code from here http://www.rondebruin.nl/copy3.htm, specifically the "Merge a range from every workbook you select (below each other)" piece.

The tweak I want to make is that I want to transpose the data from two blocks of 4 col x 17 rows, into one long row.

I just do not know where to start, I've scoured the internet and my trusty VBA for dummies but have to admit I'm getting no where.

I've attached a worksheet showing the source data, the code I have follows:

Please Login or Register  to view this content.

Any help will be gratefully received!

Thanks
Paul