title: Excel Table into Organized Pandas Dataframe
body: <p>I have an excel worksheet with data stored in the following way.</p>
  
  <p><a href="https://i.stack.imgur.com/8wtTj.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8wtTj.png" alt="enter image description here"></a></p>
  
  <p>I would like to organize this data into a Pandas dataframe so that it looks like the following...</p>
  
  <p><a href="https://i.stack.imgur.com/qXaCf.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qXaCf.png" alt="enter image description here"></a></p>
  
  <p>Having the data formatted like this will allow me to easily work with pivot tables and carry out analysis. </p>
  
  <p>If there is an easy way to do this in excel as well, please let me know. Python would be the better choice, since I have hundreds of tables like this each with hundreds of rows and columns. </p>