+ Reply to Thread
Results 1 to 4 of 4

Data from X columns into 1 column

  1. #1
    Registered User
    Join Date
    08-22-2014
    Location
    Belgium
    MS-Off Ver
    2013
    Posts
    2

    Data from X columns into 1 column

    Hi all!

    I've got a small issue concerning a macro in Excel.

    I've got a lot of data stored in different columns with different amount of rows (1 column has 100 rows, other has 80 rows for instance). I would like to put all this data into 1 column, instead of copy'ing them one by one . So I'm looking for a formula/macro which takes into account the following things:
    • a selection.end(x1Down) per column
    • a selection.copy
    • go to the new column, find the first empty cell here and paste it below
    • go back to original table, go to the next column and repeat the above steps (select all, copy, select empty cell, paste)
    • macro should end when there are no more columns

    I will post an example file!

    I hope you can help me with this, thanks!!

    Kind Regards,

    VDV

    Different columns to one.xlsx

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Data from X columns into 1 column

    Try
    Sheet "Data" is the active one
    Please Login or Register  to view this content.
    - Battle without fear gives no glory - Just try

  3. #3
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Data from X columns into 1 column

    Try the attached.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    08-22-2014
    Location
    Belgium
    MS-Off Ver
    2013
    Posts
    2

    Re: Data from X columns into 1 column

    Works like a charm! Thanks guys

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Combining data in multiple columns(all columns have same length)into one column
    By nzi0001 in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 07-24-2014, 11:19 AM
  2. Replies: 3
    Last Post: 07-21-2014, 01:34 PM
  3. [SOLVED] Convert column B as multiple column titles and move data in column C into new columns?
    By princesscathryn in forum Excel - New Users/Basics
    Replies: 8
    Last Post: 06-30-2014, 07:31 PM
  4. Replies: 5
    Last Post: 05-14-2014, 08:35 AM
  5. Add two columns and fill columns based on other column data
    By gcoug in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-21-2011, 06:52 PM

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