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

1. ## 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

2. ## 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. ## 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. ## 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

##### Users Browsing this Thread

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

#### 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