Question: how to transfer data from one cell to another?
Answer: Select the cell or range of cells that contains the data that you want to move or copy. ...  On the Home tab, in the Clipboard group, do one of the following: ...  Right-click the upper-left cell of the paste area, and then click Insert Cut Cells or Insert Copied Cells.