title: sql server transpose rows to column value
body: <p>I have a table that looks like this:</p>
  
  <pre><code>Project | State
  ----------------
  1       | A
  2       | A
  2       | F
  3       | A
  3       | F
  3       | P
  4       | S
  5       | C
  </code></pre>
  
  <p>What i would like to to is get a table like this :</p>
  
  <pre><code>Project | State
  ----------------
  1       | A
  2       | AF
  3       | AFP
  4       | S
  5       | C
  </code></pre>
  
  <p>Is it possible to do this ?</p>