There are 6000 more rows and a few more columns. As we can see in the image, exactly half the rows have duplicate information except for one box/variable (FEV1). We want to create a new column called FEV2 (in place of E3, E4, E5...) containing value of the one unique variable in every alternate row (D4, D6, D8...) and delete the ~3000 duplicate rows. Kindly help. I can also open the file in MS Excel, so excel procedures would also be welcome.
... View more