title: transform data set so that each record represent unique place rather than multiple records for same place using r
body: <p>I have a dataset with following records:</p>
  
  <pre>
  
  ID type    description name   colony zip
  
  1  officer1 general    sam    maria  20909
  1  officer2 general    phil   maria  20909
  1  officer3 general    horton maria  20909
  2  officer1 general    tony   santa  20979
  
  </pre>
  
  <p>I want my output to be :</p>
  
  <pre><code>ID  description  colony   zip     officer1 officer2 officer3
  
  1   general      maria    20909   sam      phill    horton
  2   general      santa    20979   tony  
  </code></pre>
  
  <p>How can i achieve this using r, I want zip or location to be unique</p>