title: Un-Pivot table in Excel 2011 on Mac
body: <p>On Windows (Excel 2007), there is a way of unpivoting a table by pressing alt + d then p then selecting multiple consolidation ranges then I will create my page fields then finish. This creates a pivot look which appears like the data but double clicking on the grand total provides an unpivoted look at the data.</p>
  
  <p>How can I achieve the same thing using Excel 2011? Alt + D does not seem to work on a Mac… any advice?</p>
  
  <p>Thank you.</p>