Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 57
  • 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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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