+ Reply to Thread
Results 1 to 4 of 4

Making one column out of two columns where either one of them contains numbers

  1. #1
    Registered User
    Join Date
    11-25-2021
    Location
    The Netherlands
    MS-Off Ver
    2020
    Posts
    3

    Red face Making one column out of two columns where either one of them contains numbers

    Hi guys!

    So, I have column A and column B. Both columns contain numbers. For each row under these separate columns, it's either
    the cell under column A that contains a number or a cell under column B, meaning that they don't contain data at the same time. For some
    rows, both cells are empty, this is the only exception. Now I have to make one column out of those two columns without losing data, how do I do this?

    Help is so appreciated man!!!!!!! I am really stuck

    edit.PNG
    Attached Images Attached Images
    Last edited by Bliss_06; 11-25-2021 at 07:39 AM.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,957

    Re: Making one column out of two columns where either one of them contains numbers

    Your first row of data shows two numbers, but you say in your narrative that this cannot happen. Which is it to be?

    Pete

  3. #3
    Registered User
    Join Date
    11-25-2021
    Location
    The Netherlands
    MS-Off Ver
    2020
    Posts
    3

    Re: Making one column out of two columns where either one of them contains numbers

    Thank you for noticing, I removed that one and added another screenshot. There wasn't supposed to be data there

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,957

    Re: Making one column out of two columns where either one of them contains numbers

    Put this formula in C1:

    =COUNTIF(A$1:B1,"<>")

    then copy down to the bottom of your list of numbers. Then you can use this formula in E1:

    =IFERROR(INDEX(A:A,MATCH(ROWS($1:1),C:C,0))+INDEX(B:B,MATCH(ROWS($1:1),C:C,0)),"")

    Copy down until you start to get blanks.

    Note that you may need to use semicolons ( ; ) instead of commas ( , ) in the formulae, depending on your regional settings.

    Hope this helps.

    Pete

+ 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. Making 13 columns into one column
    By twilcox1978 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-20-2015, 12:24 PM
  2. Replies: 1
    Last Post: 05-03-2014, 11:25 PM
  3. [SOLVED] Sort by the multiple of 2 columns without making another column?
    By niko79542 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-14-2012, 09:46 AM
  4. Replies: 1
    Last Post: 07-10-2010, 09:38 PM
  5. [SOLVED] Making a column of numbers created from a formula permanent.
    By jba919 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-01-2006, 02:30 PM
  6. [SOLVED] making columns automatically turn numbers into negatives
    By Kathy in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-01-2005, 02:06 AM
  7. [SOLVED] Making a One Column Directory from Two Columns
    By Dennis Hughes in forum Excel General
    Replies: 1
    Last Post: 01-21-2005, 12:06 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