title: Read excel row by row and do transpose, Python 3.6
body: <p>I have excel file with below data and I want to read data where First Column contains 'Area' &amp; transpose, then again move &amp; find where Column contains 'Area' &amp; transpose</p>
  
  <p>In this data total 3 table data given, I want to split it &amp; then transpose. First Column contains <strong>Area code</strong> and other column name contains <strong>Year</strong></p>
  
  <pre><code>Area    1980    1981    1982    1983
  AU  33.7    38.8    40.2    42.5
  BE  54.6    51.6    49.7    48.9
  FI  43.2    49.6    58.8    71.1
  Area    1979    1980    1981    1982
  AU  29.8    33.7    38.8    40.2
  BE  54.2    54.6    51.6    49.7
  CA  39.4    44.3    50.6    48
  Area    1978    1979    1980    1981
  DK  58  57.2    54.5    53.2
  FI  37.7    43.2    49.6    58.8
  FR  41.6    49.9    55.4    58.5
  </code></pre>
  
  <p>Final Result expected:</p>
  
  <pre><code>Area    variable    value
  AU  1980    33.7
  other values
  </code></pre>
  
  <p>How to achieve this?</p>