# Combining Multiple Columns without stacking

1. ## 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  Register To Reply

2. ## 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  Register To Reply

3. ## Re: Combining Multiple Columns without stacking

In A1 use ``Please Login or Register  to view this content.``
Then Drag down  Register To Reply

4. ## Re: Combining Multiple Columns without stacking

Duplicate post.  Register To Reply

5. ## Re: Combining Multiple Columns without stacking

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