title: Openpyxl Merge cells with same value in one column
body: <p>I have write the dataframe below to an excel file </p>
  
  <pre><code>df = {'name':  ['a', 'b', 'b', 'b', 'c', 'd', 'd', 'e'],
          'type': ['tiger', 'caterpillar', 'butterfly', 'butterfly', 'dolphin', 'tadpole', 'frog', 'dog'],
          'month1_weight': ['33', '0', '0', '0', '59', '3', '0', '0'],
          'month2_weight': ['0', '0', '20', '20', '65', '0', '10', '2'],
          }
  dataframe = pd.DataFrame(df)
  
  name      type         month1_weight  month2_weight
  a         tiger        33             0
  b         caterpillar  0              0
  b         butterfly    0              20
  b         butterfly    0              20
  c         dolphin      59             65
  d         tadpole      3              0
  d         frog         0              10
  e         dog          0              2
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/vFLZO.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/vFLZO.png" alt="enter image description here"></a></p>
  
  <p>How can I merge the cells in the name column in Excel and make it be like this:</p>
  
  <p><a href="https://i.stack.imgur.com/a0mbk.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/a0mbk.png" alt="enter image description here"></a></p>