From: Jon in the U&L on
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!