PIVOT TABLE IN EXCEL 2007

  • Thread starter Thread starter sid
  • Start date Start date
S

sid

I want create a pivot table using an external database. I can do it but the
list of column data appears all in column A instead of column B, C, D etc.
How do I get the data into columns with its appropriate headers?
 
Select a cell in the pivot table
On the Ribbon, under PivotTable Tools, click Design
In the Layout group, click on Report Layout
Click on Show in Outline Form or Show in Tabular Form
 
Back
Top