Way to repeat row item name on pivot table-no "indent" of repeats

A

Apprentice

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
 
S

Shane Devenshire

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
 
S

Shane Devenshire

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(B3>1,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
 
A

Ashish Mathur

Hi,

Try this. Highlight A2:A50 (adjust to match you range). Now
Ctrl+G>Special>Blanks. 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top