Copying multiple variable length columns to one

[vectistim]

Once again vba syntax has defeated me, so hopefully someone can help.

I have data as in the dummy file attached.
The first entry in each column is a label, eg: B2, then the values B3:B7 all belong to B2

I want to reorganize the data into two columns that look like this:
B2 B3
B2 B4
B2 B5
B2 B6
B2 B7
C2 C3
C2 C4
etc. as shown in the attachment

Thank you.

[Sean Thomas]

Does your data always start in column B?

[vectistim]

It can do. (The real data will be 12 files with about 150 columns each with about 700 rows in each column)

Thank you.

[vectistim]

I've managed to find a solution, from this thread
http://www.mrexcel.com/forum/excel-q...ng-ranges.html

I've amended the code in that file slightly, as follows:

Please Login or Register  to view this content.

I also shifted my data to start at A1.

[Sean Thomas]

hmm, based on your data supplied. If you don't have the results underneath when you run it this will work

Please Login or Register  to view this content.

Its very difficult writing code unless you know the precise layout of your data and where you want the results to be.