From http://www.contextures.com/xlfaqPivot.html

How do I get the row field headings to repeat in a pivot table?
The row headings show once in a PivotTable, and there's no setting you can
change, to force them to repeat. To create a table with a heading on each
row, you could copy the pivot table, paste it as values in another location,
and fill in the blanks. In the beta version of Excel 2010, this feature is
finally available.

If you want to copy and paste the pivot as values only I can show you a
technique to easily fill in the blank. Let me know if that is of interest...
--
HTH...

Jim Thomlinson


"Jon in the U&L" wrote:

This is working, Jim. Thanks so much.

Follow-up question, more a formatting question I guess: I need the duty
location, state, title, pay plan, series, and grade to appear on every line.
What's happening is that, for example, for Account Services Manager there
will be one entry and then two duty locations rather than repeating the
position title.

Any help on that one?

My goodness, thanks, again, Jim!

"Jim Thomlinson" wrote:

I took your Source data and did the following...

Created a pivot Table from the data (I think you are good to here)
Placed the Duty Location in the Left Column (not top row)
Placed the State to the immediate right of the Location (not in the data
section)
... same thing for all of the remaining fields
Place FTE's in the data section.

Pivot tables like to add in subtotals. You can remove the subtotals by right
clicking on the field and select Field Options - Aggregation - None. Do
that for each field. You will end up with this

Sum of FTE
DUTY LOCATION STATE POSITION TITLE PAY PLAN GRADE SERIES Total
Portland OR Administrative Specialist GS 11 301 1
Seattle WA Administrative Specialist GS 12 301 1
Vancouver WA Administrative Specialist GS 13 301 2
Washington DC Administrative Specialist GS 12 301 1
Grand Total 5
If you ignore the text wrap it look exactly like what you wanted...

--
HTH...

Jim Thomlinson


"Jon in the U&L" wrote:

DUTY LOCATION STATE POSITION TITLE PAY PLAN GRADE SERIES FTE


Washington DC Administrative Specialist GS 12 301 1
Portland OR Administrative Specialist GS 11 301 1
Seattle WA Administrative Specialist GS 12 301 1
Vancouver WA Administrative Specialist GS 13 301 1
Vancouver WA Administrative Specialist GS 13 301 1

See the 2 positions in Vancouver WA in the same Grade? Ultimately I want to
end up with a worksheet that consolidates those two rows and totals the FTE
count thereby eliminating duplicate titles in the same grade, series, and
location.

I.e.:
Vancouver WA Account Specialist GS 13 1101 2

Thanks for your patience and help, Tom, it is really appreciated.


"Jim Thomlinson" wrote:

Can you post a small snippet of data that I can play with. How did you want
to handle Accountants in both MI and WA. My experience with this is that
there is a lot of mix and match of data.
--
HTH...

Jim Thomlinson