Pivot
Employee Quarter Sales
A 1 100
2 115
3 120
4 105
B 1 150
2 120
Format needed
Employee Quarter Sales
A 1 100
A 2 115
A 3 120
A 4 105
B 1 150
B 2 120

Hi

Here is an inelegant way:

Add another column to your data sourse. In that column enter 1,2,...
Add this field as the first field in the row area. Double-click its field
button and set subtotals to None. Highlight all the cells in the new column
including its button and choose Format, Cells, Number tab, Custom and on the
type row enter ;;;
if you can stand not seeing the Sum of Sales button you can hide the column
and/or its row.

If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Apprentice" wrote:

Pivot
Employee Quarter Sales
A 1 100
2 115
3 120
4 105
B 1 150
2 120
Format needed
Employee Quarter Sales
A 1 100
A 2 115
A 3 120
A 4 105
B 1 150
B 2 120

Hi,

Here is another approach since you are only looking at 4 qtrs, I personally
don't think much of it but it works:

Suppose your original data was in A1:C100, titles on row 1, then in D2 enter
the formula

=A3&IF(B31,REPT(" ",B3),"")

Copy this down, title this column Emp. or whatever, add this column to the
pivot tables source and put it in the first position. Removing the old emp
field. Sort this new field.

If this helps please click the Yes button

Cheers,
Shane Devenshire

"Apprentice" wrote:

Pivot
Employee Quarter Sales
A 1 100
2 115
3 120
4 105
B 1 150
2 120
Format needed
Employee Quarter Sales
A 1 100
A 2 115
A 3 120
A 4 105
B 1 150
B 2 120

Hi,

Try this. Highlight A2:A50 (adjust to match you range). Now
Ctrl+GSpecialBlanks. Now press = Up arrow key Enter. This should
plug in all blanks with the value in the cell right above.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Apprentice" wrote in message
...
Pivot
Employee Quarter Sales
A 1 100
2 115
3 120
4 105
B 1 150
2 120
Format needed
Employee Quarter Sales
A 1 100
A 2 115
A 3 120
A 4 105
B 1 150
B 2 120