Pivot Tables

The UK's most regular instructor-led training courses.
Training information: excel computer training · Excel courses london · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2003

1 post

ReplyWed 9 Dec 2009, 16:00Delegate Ceris said...

Ceris has attended:
Excel Advanced course

Pivot Tables

can you have two cell fields eg first name, surname in the pivot table

Version	Date	Location	Places available	Book	Next place rate (£)		List price
Excel VBA Intro Intermediate 2 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice	List price
2007	Mon 9 + Tue 10 Aug 2010	Bloomsbury	0	FULL			£495
2003	Wed 11 + Thu 12 Aug 2010	Southwark	3		£495	£495	£495
2003	Wed 25 + Thu 26 Aug 2010	Bloomsbury	8		£450	£455	£495
2007	Thu 2 + Fri 3 Sep 2010	Bloomsbury	5		£490	£495	£495
2003	Wed 8 + Thu 9 Sep 2010	Southwark	8		£450	£455	£495
2003	Tue 21 + Wed 22 Sep 2010	Southwark	8		£450	£455	£495
Full Schedule: See all 47 Excel VBA Intro Intermediate course dates. Bookings currently available until 28th September 2011.

1,145 posts

ReplyFri 11 Dec 2009, 12:49Trainer Andrew said...

RE: Pivot Tables

Hi Ceris

Thank you for your question. This should work where there is a one to one mapping between the fields. An employee number column and name column for example. You should be able to add these to the data row area without Excel grouping the data.

I hope this helps - do let us know if you have any further questions.

Kind regards,
Andrew

Fri 18 Dec 2009: Automatically marked as resolved.

· How To Use Excel To Create Large SQL Insert Statements
· Tools From Advanced Excel Courses: Goal Seek and Solver
· Why Should I Learn Visual Basic in Excel?
· Simple Ways To Customise Excel
· 5 Microsoft Excel Charts for Creating Stunning Business Documents

Please browse our web site to find out more about
excel computer training and other Microsoft training courses.