Stacking columns on top of every other?

H

holo man

Guest
I have a table with: 256 columns by 256 rows. I would like to heap all the columns ahead of every another to create one long-column of 65,536 rows. Any assistance?
 
A quick macro


Code:
    For i = 2 To 256

        Cells(1, i).Resize(256).Copy Cells((i - 1) * 256 + 1, 1)
    Next i
 
Back
Top