Pivot Table with additional data columns past last pivot field

[NHagedorn]

How do I design a pivot table that will allow me to add additional data past the last pivot table fields? In the example below would set up pivot table in rows for Name, Address, City, State, Site ID. But would like to have he additional data to also be added... DataX, DataY, DataZ.

Thank you

Name	Address	City	State	Site ID	DataX	DataY	DataZ
Bob	1 Main St.	Edgewood	KY	24	423545	24524	25
Bob	2 Main St.	Edgewood	KY	24	42	2	2
Bob	3 Main St.	Edgewood	KY	24	2452	24254	6474
Bob	4 Main St.	Edgewood	KY	24	2467	3456	343546
Jane	55 Robert St.		OH	80	33456	5678	35634
Jane	56 Robert St.		OH	80	2452	7353	563
Mary	4 Dover St.	Clifton	OH	896	442552	4	5
Mary	5 Dover St.	Clifton	OH	896	976	98765445	69886
Mary	6 Dover St.	Clifton	OH	896	34678	34567	57
Mary	4 Dover St.	Clifton	OH	3536	2452	252	237

<colgroup><col width="64" style="width: 48pt;" span="8"> <tbody> </tbody>

Desired End Product....

Name	Address	City	State	Site ID	DataX	DataY	DataZ
Bob	1 Main St.	Edgewood	KY	24	423545	24524	25
				24	42	2	2
				24	2452	24254	6474
				24	2467	3456	343546
Jane	55 Robert St.		OH	80	33456	5678	35634
				80	2452	7353	563
Mary	4 Dover St.	Clifton	OH	896	442552	4	5
				896	976	98765445	69886
				896	34678	34567	57
Mary	4 Dover St.	Clifton	OH	3536	2452	252	237

<colgroup><col width="64" style="width: 48pt;" span="8"> <tbody> </tbody>

Thanks