Excel 2010 pivot table rows

Question

I have a data sheet with the following headings:

Last Name

First  Name

FTE

Budget

YTD Spending

I put Last Name and First Name in the Row Labels and FTE, Budget, and YTD Spending in Values.  My pivot table is showing last name on one row, first name on the next row.  I would like them on one line.  I think in Excel 2003, I was able to do this by clicking on "Data" above my data columns, choosing Order, and Move to Columns. 

Moving Last Name and First Name to the Column Labels areas gives me the same effect with Last Name and First Name in different rows.  How can I get Last Name and First Name to appear on the same row?

Answer 1

Open PivotTableTools Ribbon -> Options -> Options (at far left) -> Display -> check the Classic PivotTable Layout option.

---

Ed Ferrero www.edferrero.com

Answer 2

Thanks!  That did it!