title: Mix of columns in excel to one colum with Pandas
body: <p>I have to import this Excel in code and I would like to unify the multi-index in a single column. I would like to delete the unnamed columns and unify everything into one. I don't know if it's possible.</p>
  <p><a href="https://i.stack.imgur.com/kcpZ5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/kcpZ5.png" alt="Excel table" /></a></p>
  <p>I have tried the following and it imports, but the output is not as expected. I add the code here too</p>
  <pre class="lang-py prettyprint-override"><code>import pandas as pd
  import numpy as np
  
  macro = pd.read_excel(nameExcel, sheet_name=nameSheet, skiprows=3, header=[1,3,4])
  macro = macro[macro.columns[1:]]
  macro
  </code></pre>
  <p><a href="https://i.stack.imgur.com/5w0nM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5w0nM.png" alt="Code tried" /></a></p>