<div>
<div class="content wysiwyg-content">
i have 3 columns. &nbsp;columns 1 - 3 will all have 1 value per row. &nbsp;the value can be in any column but, the other 
two columns will always be blank. 
 
col1 &nbsp; col2 &nbsp; col3 
a &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; b 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;c 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;d 
b 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; a 
 
desired result below 
col4 
a 
b 
c 
d 
b 
a 
 
can anyone do a formula in excel for this?
</div>
</div>

i have 3 columns.  columns 1 - 3 will all have 1 value per row.  the value can be in any column but, the other
two columns will always be blank.

col1   col2   col3
a         
            b
                     c
             d
b
            a

desired result below
col4
a
b
c
d
b
a

can anyone do a formula in excel for this?

combining 3 columns into one

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.