Pivot Table in Excel 2007?????

[OldManEd]

Why did Microsoft complicate the creation of a simple pivot table????

I now have a single column of the data I want in a table:

Col A

1
7/1/2005
$210.00
7/14/2005
$120.00
8/4/2005
$180
etc


I want:
1 2 3 etc
7/1 210.
7/14 120.
8/4 180
etc

How do I get from a single column to a multi column/row??? It was so easy
before!!! Now?????

OMEd

 

[ShaneDevenshire]

Hi,

This interests me greatly. I put your sample data into one column of a
spreadsheet and made a pivot table from it using 2003 but I could not reach
the layout you show. Could you step us through the process - in 2003?

 

[Debra Dalgleish]

Select a cell in the pivot table
On the Ribbon, under PivotTable Tools, click the Design tab
In the Layout group, click on Report Layout
Click either Show in Outline Form or Show In Tabular Form

 

[OldManEd]

Does not create a table.
OMEd

Select a cell in the pivot table
On the Ribbon, under PivotTable Tools, click the Design tab
In the Layout group, click on Report Layout
Click either Show in Outline Form or Show In Tabular Form



--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

 

[Roger Govier]

Hi
That should work.
what do you get?