Hi, I have a big data with hundreds variables, each variable has a missing value that across all the variables diagonally. The data looks like: ID X1 X2 X3 X4 X5 ...... Xn 1 . 2.1 3.1 4.1 5.1 ..... 2 1.2 . 3.3 4.5 5.3 3 1.3 2.2 . 4.4 5.5 4 1.4 2.3 3.6 . 5.1 5 1.8 2.9 3.0 4.7 . ... ; How could I move one row up for each variable (one row less in the end), and the result I wanted is: ID X1 X2 X3 X4 X5 ...... Xn 1 1.2 2.1 3.1 4.1 5.1 ..... 2 1.3 2.2 3.3 4.5 5.3 3 1.4 2.3 3.6 4.4 5.5 4 1.8 2.9 3.0 4.7 5.1 ... ;
... View more