title: How to convert multiple rows to one row in SQL Server?
body: <p>I have a problem with a query. Let's say I have two tables named <code>PersonInfo</code> and <code>PersonEducation</code>. I applied join operation on these tables with <code>StudentId</code> and I have  a result like that.</p>
  
  <pre><code>   StudentIdId      Name    University    Department     Status
     ---------------------------------------------------------------
        1             John    Cambridge     Computer       Graduated
        1             John    Berkeley      Mathematic     Graduated
        1             John    Boston        Economy        Ongoing
  </code></pre>
  
  <p>It is just one example of a student (John). It shows that John graduated from 2 university and still studying in one university. University numbers can change depending on the students. My question is that how can I show these 3 row in just 1 row. I mean I want to show all education information in one row in order not to have multiple rows for one person. </p>
  
  <p>Thanks in advance for your help.</p>