title: How to get all rows and store it into single row based on duplicate column in mysql
body: <p>I have a Table like below:</p>
  
  <pre><code>Id  Name   Email
  1    A     email1@gmail.com
  2    B     email1@gmail.com
  3    C     email1@gmail.com
  4    d     email2@gmail.com
  5    E     email3@gmail.com
  6    F     email3@gmail.com
  </code></pre>
  
  <p>Expected output(while searching from an email)</p>
  
  <pre><code>Id    Name1  Name2   Name3  Email
  
  1     A      B       C      email1@gmail.com
  </code></pre>
  
  <p>How to get this result using mysql query?</p>