Hi,

I am trying to copy and paste the first 20 observation onto a new column but the values start at the 10th row and not the first row. I tried manually copying and pasting it by clicking and selecting the observations and finally pasting them to the selected cells in the new column but it seems rather time consuming, especially since I am doing it for multiple columns at a single time. Here is an example of my dataset:

Array

As you can see, I want the data from the first 20 rows in the column "mergeddata" to be inputted into the second column "mergeddate_01" but the data has to start at the 10th row instead of the first row. What I did so far was to select the first 20 observations by clicking the cells and pasting it to the new column at the 10th row but this process is time-consuming if there are many columns to be created. For the third column, I intend to have observations from the 40th observation in the first column onwards but the data to start at the 21st row instead of the first row. Is there a STATA command to automate the process? I am using the STATA version 16 and any help would be appreciated. Thanks!