Question: how to transfer data from one column to another column in excel?
Answer: Select the cell, row, or column that you want to move or copy.
Do one of the following: To move rows or columns, on the Home tab, in the Clipboard group, click Cut . ... 
Right-click a row or column below or to the right of where you want to move or copy your selection, and then do one of the following: