title: Pivot using single column and no aggregate function
body: <p>I have a doubt. I have a column called "ID". In that column I have values like "FieldName" followed by "FromDate", "Value" followed by "2012/12/01" , "FieldName" followed by "ToDate" Value "2013/12/01" etc.,</p>
  
  <pre><code>**ID column**    
          FieldName
          FromDt
          Value
          2010/12/01
          FieldName
          ToDt
          Value
          2013/12/21
          FieldName
          CreatedDt
          Value
          2012/10/01
          FieldName
          ModifyDt
          Value
          2013/01/02
  </code></pre>
  
  <p>Now I want a table like </p>
  
  <pre><code>**FieldName  Value**
  FromDt      2010/12/01
  ToDt        2013/12/21
  CreatedDt   2012/10/01
  ModifyDt    2013/01/02
  </code></pre>
  
  <p>Is it possible to use pivot with a single column and without aggregate function? Kindly suggest me how can I do this? (either using Pivot or some other methods)</p>
  
  <p>Regards,
  T.N.Nagasundar</p>