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.