Stacking columns on top of every other?

[holo man]

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?

[Bob Phillips]

A quick macro





For i = 2 To 256

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