• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 64
  • Last Modified:

Keeping duplicate data row in an Excel 2010 pivot

Hi:

 My pivot is removing duplicate data row. Is there a way to preserve this?

thx
0
LuckyLucks
Asked:
LuckyLucks
  • 2
1 Solution
 
ProfessorJimJamCommented:
please see the screenshot. click anywhere in the pivot table then click on the contextual tab of "Design" then click on the "Report Layout " then click on the "Repeat All Item Labels"

2016-08-31-13_31_38-Microsoft-Excel-.png
0
 
LuckyLucksAuthor Commented:
thx
0
 
ProfessorJimJamCommented:
you are welcome.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now