Question: how to copy data from multiple columns into one column in excel?
Answer: #1 type the following formula in the formula box of cell F1, then press enter key.
#2 select cell F1, then drag the Auto Fill Handler over other cells until all values in range B1:D4 are displayed.