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
LuckyLucksAsked:
Who is Participating?
 
ProfessorJimJamConnect With a Mentor Commented:
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
All Courses

From novice to tech pro — start learning today.