title: Excel: how to merge duplicate rows of a column , leaving the rest of column data as it is
body: <p>My Excel will be populated using query now the below is the data set which is coming!</p>
  
  <pre><code>COL A                                         COL B     COL C  COL D
  Claims on Public Sector Entities in Pakistan              0%    0 
  Claims on Public Sector Entities in Pakistan    1         20%   0 
  Claims on Public Sector Entities in Pakistan    2,3       50%   0 
  Claims on Public Sector Entities in Pakistan    4,5       100%  0 
  Claims on Public Sector Entities in Pakistan    6         150%  0 
  Claims on Public Sector Entities in Pakistan    Unrated   50%   0 
  Claims on Banks                                           0%    245,608 
  Claims on Banks                                           10%   0 
  Claims on Banks                                  1        20%   0 
  Claims on Banks                                2,3        50%   0 
  Claims on Banks                                4,5        100%  0 
  Claims on Banks                                6          150%  0 
  Claims on Banks                                Unrated    50%   0 
  </code></pre>
  
  <p>and what i want is</p>
  
  <pre><code>COL A                                         COL B     COL C  COL D
  Claims on Public Sector Entities in Pakistan              0%    0 
                                                  1         20%   0 
                                                  2,3       50%   0 
                                                  4,5       100%  0 
                                                  6         150%  0 
                                                  Unrated   50%   0 
  Claims on Banks                                           0%    245,608 
                                                            10%   0 
                                                   1        20%   0 
                                                 2,3        50%   0 
                                                 4,5        100%  0 
                                                 6          150%  0 
                                                 Unrated    50%   0 
  </code></pre>
  
  <p>i want my column A to get merge but i want my other columns data as it is</p>