title: Merge partially duplicate rows into one row in Access
body: <p>I have a select query, it gives out rows that are partially duplicate, I want to the duplicate rows to be merged into one row with the non duplicate values to be comma separated. 
  Current output of the query is:</p>
  
  <pre><code>    **Contacts           Department                    Type**    
      Elena Stone          Biology                       Impact
      Elena Stone          Biochemistry                  Impact
      Elena Stone          Biotechnology                 Other
  </code></pre>
  
  <p>My desired output should be:</p>
  
  <pre><code>    **Contacts           Department                                 Type**   
       Elena Stone          Biology,Biochemistry,Biotechnology        Impact,other
  </code></pre>
  
  <p>Can some one please help me how to get this.
  Thank You</p>