Pivot table confusion in excel 2007

  VNAM75 15:56 02 Sep 08
Locked

I've just installed excel 2007 (from 2003)and trying to create a pivot table. I have 4 fields in the Row area and instead of them being shown horizontally in cells A3:D3, they are all under column A and I have to drill down to see the data. The data is there but you don't know which field they relate to.
How can get it show the field names in the old pivot table format?

  VoG II 17:10 02 Sep 08

This may help click here

  VNAM75 19:30 02 Sep 08

Thanks VoG, I'd worked it out earlier but your link has the answer too and other useful information.

This thread is now locked and can not be replied to.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…