Share via

Need Pivot Table to display duplicate entries in columns

Anonymous
2015-06-21T08:37:34+00:00

I have a Pivot table with Department ID  together with Org Code, User etc.

When I setup a pivot Department ID is displaying only for the first user type and not for the others, they are showing as blanks

How can I get Organization ID and Department code display for all of the records.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Vijay A. Verma 104.7K Reputation points Volunteer Moderator
    2015-06-21T10:51:31+00:00
    1. Click anywhere in your pivot.
    2. Design Tab > Report Layout > Repeat All Item Labels (This will repeat item labels for all items)

    1. If you want to repeat only for selective item labels -

    3.1 Right click on that item label.

    3.2 Choose Field Settings

    3.3 Layout and Prints > Repeat Item Labels

    7 people found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2015-06-21T11:24:56+00:00

    Hi Vijay - This is working fine when I do not apply sort order - when I say sort by Dept (A-Z) the value is displayed only once. Probably I am doing something silly.

    0 comments
  2. Vijay A. Verma 104.7K Reputation points Volunteer Moderator
    2015-06-21T11:51:23+00:00

    Sorting will not cause this problem which you are describing. 

    How are you performing sort?

    0 comments