Pivot Table

[Brig]

From Excel 2003, is there a way to format the pivot table result to have the
Data section to span through columns instead of rows?

Let say I chose 2 Data elements per Zip code: No of Patients, No of
Doctors,

What I want to happen is the following;
Zip Code (Criteria): Column A
No of Patients: Column B
No of Doctors: Column C

What is happening right now is that both No of Patients and No of Doctors
are in Column B on top of each other.

Is there a way to do this?

Thank you in advance.

 

[Dave Peterson]

You have an indicator column in your raw data, right?

Drag that to the column field instead of the data field.

And drag the zip code to the data field (use count of zipcode).

If you've already finished your pivottable, look at Debra Dalgleish's video:
http://contextures.com/xlVideo001.html

 

[Brig]

That worked. Thank you so much!

--
Brig Siton

You have an indicator column in your raw data, right?

Drag that to the column field instead of the data field.

And drag the zip code to the data field (use count of zipcode).

If you've already finished your pivottable, look at Debra Dalgleish's
video:
http://contextures.com/xlVideo001.html