title: How this could be done in my-sql?
body: <pre><code>CREATE TABLE Table1
      (`id` int, `group_id` int, `data_id` int, `value` varchar(19))
  ;
  
  INSERT INTO Table1
      (`id`, `group_id`, `data_id`, `value`)
  VALUES
      (1, 20, 15, 'Supplier'),
      (2, 20, 1, 'Rahul'),
      (3, 20, 2, 'Sharma'),
      (4, 20, 3, '05/08/90'),
      (5, 20, 4, 'india'),
      (6, 21, 15, 'Consumer'),
      (7, 21, 1, 'Rajesh'),
      (8, 21, 2, 'Sharma'),
      (9, 21, 3, '05/08/88'),
      (10, 21, 4, 'india')
  ;
  </code></pre>
  
  <p>A table is created now i have to sort data in values column by either supplier or consumer the would be like :
  For Consumer :</p>
  
  <pre><code>f-name l-name    dob     location
  -----------------------------------
  Rajesh Sharma 05/08/88   india
  and so on .... 
  </code></pre>
  
  <p>For supplier</p>
  
  <pre><code>f-name l-name    dob     location
  -----------------------------------
  Rahul Sharma 05/08/90   india
  </code></pre>