title: Flattening Nested Excel Using Python
body: <p>I have an excel with nested rows that look like below:</p>
  <p><a href="https://i.stack.imgur.com/04N9C.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/04N9C.png" alt="enter image description here" /></a></p>
  <p>...</p>
  <p>I want to flatten it and have the output as below:</p>
  <p><a href="https://i.stack.imgur.com/rJ4iM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/rJ4iM.png" alt="enter image description here" /></a></p>
  <p>Does anyone know a good way of doing this in Python/Pandas?</p>
  <p>Thanks</p>