+ Reply to Thread
Results 1 to 5 of 5

Combining Multiple Columns without stacking

  1. #1
    Registered User
    Join Date
    03-27-2013
    Location
    DC
    MS-Off Ver
    Excel 2007
    Posts
    4

    Combining Multiple Columns without stacking

    Column A is blank, Columns B-E have data that is scattered (with blanks). I Need the formula to look in B-E and the first cell it finds that has data it takes and puts it in A. So in the end all data with be in column A and no data in B-E. Therefore, there is no stacking involved and the row does not change that the data is on, only the column changes (all data will be in column A).

    Current Data
    A B C D E
    1
    2
    1
    3
    2
    4
    2

    End Result

    A B C D E
    1
    2
    1
    3
    2
    4
    2

  2. #2
    Registered User
    Join Date
    08-20-2012
    Location
    High Wycombe, England
    MS-Off Ver
    Excel 2010
    Posts
    46

    Re: Combining Multiple Columns without stacking

    I assume that only 1 column contains data in each row? So the data is in either B, C, D or E?

    If it is numbers then you can just do =sum(B1:E1) and then do a copy paste special to put the values in column A without the formulas.

    If it is text then this is the formula I'd use, not sure if it's the most efficient.

    =if(isblank(B1),(if(isblank(C1),(if(isblank(d1),(if(isblank(e1),"0",e1)),d1)),c1)),b1)

    if you again do a copy and paste special; values, then you'll then lose the formulas and be able to remove the data from Columns B-E.

    Hope that helps

  3. #3
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: Combining Multiple Columns without stacking

    In A1 use

    Please Login or Register  to view this content.
    Then Drag down

  4. #4
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: Combining Multiple Columns without stacking

    Duplicate post.

  5. #5
    Registered User
    Join Date
    03-27-2013
    Location
    DC
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Combining Multiple Columns without stacking

    Thank you that was very helpful. I apologize for duplicating this question. I'll look harder next time.

+ 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