I know there has to be a easier way to move text from one cell to the next without having to select one cell at a time to copy and paste. I have information I say in B column from cell 1-2000. and information in A column from 1-2000. I will like to combined the columns as one list but I keep getting a error trying to multiple copy cells because some have blanks in them, and they need to stay on that cell row because I have other data attached to it. how do I combined both into one column without having to sort and filter first? I need a1 to stay on a1, and if b1 is blank but a1 all I should see is just a1. if they both have info then I need both of them in one cell. I hope that makes since. I can't figure out how to combine them without having to do one at a time, a few thousand will manually will not do.
<tbody>
</tbody>
a | b | total | |||||||
1 | up | blank | up | ||||||
2 | down | up | down up | ||||||
3 | blank | down | down | ||||||
4 | down | down | down down | ||||||
5 | blank | blank | blank | ||||||
6 | up | up | up up | ||||||
7 | blank | blank | blank | ||||||
8 | down | blank | down | ||||||
9 | up | blank | up |
<tbody>
</tbody>