+ Reply to Thread
Results 1 to 2 of 2

Adding two columns where only one of the cells in either column A or B contains data

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

    Talking Adding two columns where only one of the cells in either column A or B contains data

    Hello guys,
    Excel vraagstuk.PNG
    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 :D

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

    Re: Adding two columns where only one of the cells in either column A or B contains data

    This is a duplicate thread, which is not allowed on the forum. Mark this one as Solved using Thread Tools in the menu above your first post, and then continue in your other thread.

    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. [SOLVED] adding the converted data from two cells from different columns
    By khanaran in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-24-2019, 01:03 PM
  2. Replies: 12
    Last Post: 07-09-2015, 11:51 PM
  3. Merge data from cells on 2nd columns in which the cells of 1st column repeat
    By jagke in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-14-2013, 01:06 PM
  4. [SOLVED] Adding data to 2 columns if there is data in another column
    By djfscouse in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-07-2012, 09:19 PM
  5. Combining Data Columns / adding prefix to entire column
    By MC Advantages in forum Excel General
    Replies: 6
    Last Post: 01-15-2009, 03:22 PM
  6. Replies: 1
    Last Post: 01-14-2009, 01:24 PM
  7. Adding data of cells in one column and creating the additions in another
    By dberliner in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-03-2007, 10:12 AM

Tags for this Thread

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