How to copy and paste data from one column to another in Ms Excel 2013?
To paste the data from one column to an other column, follow the steps below.
Step 1: Click on the column header to select the entire column.
Step 2: Right click on the selected column header and select Copy.
Step 3: Now, Select the required column header where you want to copy the data. Right click on the selected column header and select required paste options. Data will be pasted, on the basis of the format you select in Paste options.
In the below image, data is copied from the column B to the column C.