+ Reply to Thread
Results 1 to 3 of 3

Multiple columns of data into one long column

  1. #1
    Registered User
    Join Date
    05-16-2006
    Posts
    93

    Smile Multiple columns of data into one long column

    Hi Guys,
    Does anyone know how to do a macro loop to take a variable number of columns of data (each of various length) and turn it into one column of continuous data
    ie stack one column under the other with the left column being at the top and the next column under it etc
    eg

    Before (3 columns)

    1a5
    2st
    wx4
    2 5
    3

    After
    1 (column 1 start)
    2
    w
    2
    3 (column 1 end)
    a (column 2 start)
    s
    x (column 2 end)
    5 (column 3 start)
    t
    4
    5 (column 3 end)


    Any help greatly appreciated

    B

  2. #2
    Herbert Seidenberg
    Guest

    Re: Multiple columns of data into one long column

    See
    http://tinyurl.com/rt8dp
    excel.misc, May 9, Combine Columns


  3. #3
    Registered User
    Join Date
    05-16-2006
    Posts
    93

    Thumbs up

    Thanks a lot Herbert, this works prefectly

    B

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1