+ Reply to Thread
Results 1 to 2 of 2

Merging 2 columns into 1

  1. #1
    Registered User
    Join Date
    04-24-2007
    Posts
    1

    Merging 2 columns into 1

    Hello,

    I have data in two adjacent columns that must be merged into one column. For example, the raw data looks like this:

    0.03027 0.03074
    0.05476 0.05576
    0.06385 0.06471
    0.08252 0.08477
    0.14771 0.14794

    And I need to merge them into one column, where the 2nd column gets inserted every other row. For example:

    0.03027
    0.03074
    0.05476
    0.05576
    0.06385
    0.06471
    0.08252
    0.08477
    0.14771
    0.14794

    I am not sure if there is a function or a series of functions that I could use that would allow me to do this. Any help would be appreciated. Thank you in advance!

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885
    If your data starts in A1/B1, then in C1 put this formula:
    Please Login or Register  to view this content.
    Fill that down for twice as many rows as are in columns A & B.

    If your data starts elsewhere, the formula can be adjusted based on the starting rows/columns.

    Once you have the formula, you can PasteSpecial > Values into itself or into another column (and either keep or remove your original A & B columns).

+ 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