Results 1 to 2 of 2

Thread: Stacking columns on top of every other?

  1. #1
    holo man
    Guest holo man's Avatar

    Stacking columns on top of every other?

    Register for a FREE account, and/
    or Log in to avoid these ads!

    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?

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Excel Version
    A quick macro

        For i = 2 To 256
            Cells(1, i).Resize(256).Copy Cells((i - 1) * 256 + 1, 1)
        Next i

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts