How can I merge two columns with data where if one column's cell is empty the adjacent cell is full?

Question

Basically like this:

V

How can I quickly merge columns a and b in this way in libreoffice calc?

user_2474656 · Answer

In Excel:

in V1 enter:

=A1 & B1

and copy downward.