Question

To remove the data from one cell and paste them into another cell, you can use what options.
​

Answer 1

Answer:

Select the data you want to transpose, including all of the heading rows and columns, and the data itself, and choose Edit → Copy.

Click a cell outside the range you copied and choose Edit → Paste Special.

In the Paste Special dialog box check the Transpose box at the lower right and then click OK.

Please mark it branlist

Answer 2

Ctrl + X to cut the data and Ctrl + V to paste it in another cell.