title: Convert Column into a Column of a Multindex Dataframe (pandas)
body: <p>I have a pandas dataframe of:</p>
  <pre><code>data = {'Metric1':[-0.01, 10.5, -0.08, 10.0],
           'Metric2':[-0.04, 1.19, -0.07,6.46],
           'Metric3':[0.01, 9.02, -0.06, 8.4],
           'Macro':['GDP', 'UR', 'GDP', 'UR'],
           'Scenario':['Base', 'Base', &quot;Stress&quot;, &quot;Stress&quot;]
           } 
  df = pd.DataFrame(data)
  </code></pre>
  <p>Where my dataframe is long on the 'Scenario' column.</p>
  <p><a href="https://i.stack.imgur.com/ADBhJ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ADBhJ.png" alt="Current Dataset" /></a></p>
  <p>I need my dataframe to maintain this shape, however with the dataframe now wide on the &quot;Scenario&quot; column.  This does mean that &quot;Macro&quot; column only has unique values.  I prefer if a Multindex dataframe result is given, but its not necessary.</p>
  <p>Image below shows result:</p>
  <p><a href="https://i.stack.imgur.com/uorMK.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/uorMK.png" alt="Excel Image showing preferred outcome" /></a></p>