When merging two columns into one, I occasionally run into issues. I have a solution, however, it doesn't quite address the issue. (found here: Excel: Merge two columns into one column with alternating values)
As I understand two columns have to be one by one:
A B C
A 1 A
B 2 1
C 3 B
To get the above solution in the C column I should use:
I, therefore, input data such as A1:B4 into the formula.
How can I do that if I only want to include columns A and D that have data instead of columns B and C? Alternatively, what if I had a column from sheet A and another from sheet B?