Pivot Tables & Excel 2007
 

Just switched from Excel 2003 to 2007 and just getting to grips with
reworking my pivots from the previous version.
In 2003 Rows in Pivot should be listed sideby side, if you had a number of
Row items they would be listed in Col B, C, D etc until the numerical data.
In 2007 rows seem to be nested is there away of unnesting and showing
multiple text rows sideby side
Thanks
Cassie

Pivot Tables & Excel 2007
 

Cassie,

Try playing with the Pivot Design Layout in 2007, to get the result you're
looking for. In this case, PivotTable Tools, Design, Report Layout, Tabular
Form
--
Kevin


"Cassie" wrote:

Just switched from Excel 2003 to 2007 and just getting to grips with
reworking my pivots from the previous version.
In 2003 Rows in Pivot should be listed sideby side, if you had a number of
Row items they would be listed in Col B, C, D etc until the numerical data.
In 2007 rows seem to be nested is there away of unnesting and showing
multiple text rows sideby side
Thanks
Cassie