title: Rearrange columns into a table
body: <p>I have a space delimited file like this:</p>
  
  <pre><code>GID_1 AID_1 2
  GID_1 AID_2 1
  GID_1 AID_3 3
  GID_2 AID_1 3
  GID_2 AID_2 1
  GID_2 AID_3 2
  GID_3 AID_1 1
  GID_3 AID_2 1
  GID_3 AID_3 3
  </code></pre>
  
  <p>and I would like to transpose columns 1 and 3 by column 2 and have this:</p>
  
  <pre><code>(X)   GID_1 GID_2 GID_3
  AID_1  2     3     1
  AID_2  1     1     1
  AID_3  3     2     3
  </code></pre>
  
  <p>I've put an "(X)" because this transposition will make that field to be blank, which is fine to me.</p>
  
  <p>Please, can anyone help me on that?</p>