title: Pivoting DataFrame with multiple columns for the index
body: <p>I have a dataframe and I want to transpose only few rows to column.</p>
  
  <p>This is what I have now. </p>
  
  <pre><code>   Entity   Name        Date  Value
  0     111  Name1  2018-03-31    100
  1     111  Name2  2018-02-28    200
  2     222  Name3  2018-02-28   1000
  3     333  Name1  2018-01-31   2000
  </code></pre>
  
  <p>I want to create date as the column and then add value. Something like this: </p>
  
  <pre><code>   Entity   Name  2018-01-31  2018-02-28  2018-03-31
  0     111  Name1         NaN         NaN       100.0
  1     111  Name2         NaN       200.0         NaN
  2     222  Name3         NaN      1000.0         NaN
  3     333  Name1      2000.0         NaN         NaN
  </code></pre>
  
  <p>I can have identical <code>Name</code> for two different <code>Entity</code>s. Here is an updated dataset. </p>
  
  <p>Code:</p>
  
  <pre><code>import pandas as pd
  import datetime
  
  data1 = {
           'Entity': [111,111,222,333],
           'Name': ['Name1','Name2', 'Name3','Name1'],
           'Date': [datetime.date(2018,3, 31), datetime.date(2018,2,28), datetime.date(2018,2,28), datetime.date(2018,1,31)],
           'Value': [100,200,1000,2000]
      }
  df1 = pd.DataFrame(data1, columns= ['Entity','Name','Date', 'Value'])
  </code></pre>
  
  <p>How do I achieve this? Any pointers? Thanks all. </p>