Sorry for resetting such an old thread.

I've added two additional fields of data to this data set: Status Code and
Reason Code. I have the data for these fields only for FY09, none for FY10.
When I ran my pivot table as Jim explained below I got position titles
appearing in FY09 and FY10 along with the same state, duty location, pay
plan, series, grade to concolidate and give me a FTE for both FY09 and FY10.
However, when I ran it with these two added data fields I get:

Account Services Manager OR Portland GS 1101 14 (blank) (blank) 1
WA Spokane GS 1101 14 (blank) (blank) 1
Account Services Manager
OR Portland GS 1101 14 C A 1
WA Spokane GS 1101 14 C A 0.6

I think I understand why these two position titles with the same state, duty
location, etc are now broken out...the new data fields which have data only
for FY09.

Does anyone know a way to force these lines together where everything else
but the status and reason code match?

TIA!

"Jon in the U&L" wrote:

I have an Excel 2003 spreadsheet with Position Title, Location, Pay Plan,
Position Series, Position Grade, and FTEs. I want to organize this data by
Position Title, then Location, then Grade, and finally FTEs.

For example, I have multiple rows of Human Resources Specialist in different
locations, in different grades each with a FTE of 1. I'd like to consolidate
each row of Human Resources Specialist in the same location in the same grade
and have the row display the total number of FTEs for that title in that
grade at that location.

Thanks in advance for your help!