Getting started with a basic pivot table using a basic data table

[OaklandJim]

Pivot Table Masters

Believe it or not here's a guy who has barely worked with pivot tables. I am trying to set up what seems like a basic one. (Yeah right.) I have several events. Call them Event 1, Event 2, etc. Event is the filter data field for the pivot table. I got that to work. For the selected event I want column HEADERS for first name, last name and phone # (the same as the headers in my dataset). So rows list first name, last name and phone# for people attending the respective event. Can I even do this? If so can someone give me some guidance about how to set this up? I fiddled with pivot table setup but I am flummoxed.

The DATA table has these headers: First Name, Last Name, Phone# and Event. So rows in the DATA table have those data for each attendee.

Here is what I am trying to do with a pivot table.

Second Event (selected by filtering)
First Name Last Name Phone#
Bob Smith 555-123-4321
Tamika Brown 222-888-9999

 

[Kerryx]

Something like this

Book3
	A	B	C	D	E	F	G	H	I
1	Fname	Lname	Phone	Event		Event	Ev2
2	Fname1	Lname1	Phone1	Ev1
3	Fname2	Lname2	Phone2	Ev2
4	Fname3	Lname3	Phone3	Ev1		Fname	Lname	Phone
5	Fname4	Lname4	Phone4	Ev3		Fname2	Lname2	Phone2
6	Fname5	Lname5	Phone5	Ev2		Fname5	Lname5	Phone5
7	Fname6	Lname6	Phone6	Ev2		Fname6	Lname6	Phone6
8	Fname7	Lname7	Phone7	Ev1		Fname9	Lname9	Phone9
9	Fname8	Lname8	Phone8	Ev3
Sheet1

 

[OaklandJim]

Kerryx. Thank you very much for the answer. That looks like what I want but I cannot figure out how to do what you show. Might you give a short description of what you did to get that pivot table?

 

[Kerryx]

Right click on the Pivot Table and select Pivotable Options, Tick box marked Classic PivotTable then OK

Pivot Tabel Fields appear on right of excel screen
drag Event to Filter section, and Fname,Lname,Phone to Rows section
You should now have something like this

You dont need the Totals so carefully click on the first occurrance for example and theey should all be highlighted example, the names first

Right click on selection and select the Subtotal"Lname" , it will then disappear. do the same for Fname Totals , you can also right click on Grand Totals and Remove it

The filter on top allows you to select Event