PIVOT TABLE IN EXCEL 2007

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?
 
D

Debra Dalgleish

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
 
Top