Question: how to copy excel column into one cell?
Answer: Enable the Clipboard pane with clicking the anchor at the bottom-right corner of Clipboard group on the Home tab. ...  Select the range of cells you will move to a single cell, and copy it with pressing the Ctrl + C keys in a meanwhile.