R: Shift some rows by one column across table
<p>I have data frame X that looks like this. It has 4 columns and 5 rows.<br/></p>

<p>name  age  gender class <br/>
A &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;      12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;   M&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;      C1<br/>
B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;      10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;   F&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;      C2<br/>
C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;      M&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;    C1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;     N/A<br/>
D&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;      F&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;    C2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;     N/A<br/>
E&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;      F&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;    C1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;     N/A<br/></p>

<p>I would like to shift all data  from col 2 (age) and row 3 onward by one column to right so that gender and classes align leaving the wrongly filled age data as blank . My resulting set should look like:<br/></p>

<p>name  age  gender class <br/>
A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;      12&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;   M&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;      C1<br/>
B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;      10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;   F&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;      C2<br/>
C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;      N/A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  M&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;      C1<br/>
D&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;      N/A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  F&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;      C2<br/>
E&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;      N/A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;  F&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;      C1<br/></p>

<p>Please note: this is a situation from a very large dataset with 4 mil records and 52 cols. 
Any help will be much appreciated. Thanks in advance!</p>