Results 1 to 33 of 33

Merge Multiple column into new column

Threaded View

  1. #1
    Registered User
    Join Date
    03-13-2014
    Location
    Denver, CO
    MS-Off Ver
    Excel 2010
    Posts
    39

    Merge Multiple column into new column

    G'Day to the list.

    Have Columns J-O. Need to copy the data in each to these column to Column P
    Need to do this to multiple rows. Data needs to be separated by commas.
    J. CEPP OEM K.POC L. OEM M. OEM Assistant N.1. Den-Bldr Metro O. Private Result in Column P "CEPP OEM, POC, OEM, OEM Assistant, 1. Den-Bldr Metro, Private"
    New User of Excel 2010. Tried to select rows and use the marge function, however it deletes my source data and copies only 1st data column into result column. Have looked at several tutorials (Google Search) but none of them achieve desired result.

    I've attached a small spreadsheet and a jpeg of the spreadsheet for your review.

    Thanks in advance.
    dana
    Last edited by DanaHoff; 04-16-2014 at 02:59 PM. Reason: Tags
    dana hoffman

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Merge Multiple column in next sheet
    By dingdang in forum Excel General
    Replies: 1
    Last Post: 08-23-2012, 01:08 PM
  2. Merge first column From Multiple Sheets Into One Sheet
    By Tomboy in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-21-2012, 12:05 PM
  3. Merge column data over multiple rows
    By ArtisanInternet in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-08-2008, 11:14 AM
  4. how to merge data from multiple columns to one column
    By w8ting4hlp in forum Excel General
    Replies: 5
    Last Post: 06-22-2005, 08:05 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