Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Post History
A Q on Stack Overflow asks how to merge two columns where each row has only one populated cell. The example was from (on the left) to (on the right): a|b a 0| ...
#1: Initial revision
by
pnuts
·
2020-10-18T11:44:38Z (about 4 years ago)
Merge a pair of columns where in each row one is blank, without a formula
A [Q](https://stackoverflow.com/questions/64188649/how-can-i-merge-two-columns-with-data-where-if-one-columns-cell-is-empty-the-ad) on Stack Overflow asks how to merge two columns where each row has only one populated cell. The example was from (on the left) to (on the right):
a|b a
0| 0
|1 1
|5 5
9| 9
Although the body included:
>How can I quickly merge columns a and b in this way in libreoffice calc?
The tag set included [excel] and the only A at present is stated to be for Excel (though it works in LibreOffice Calc also). That A suggests:
=A1 & B1
in a new column and copied down.
In Excel, is there a way to avoid the need (i) for use of a third column, (ii) to copy down and (iii) a formula?