Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Keeping duplicate data row in an Excel 2010 pivot

Posted on 2016-08-30
3
Medium Priority
?
54 Views
Last Modified: 2016-09-06
Hi:

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

thx
0
Comment
Question by:LuckyLucks
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 27

Accepted Solution

by:
ProfessorJimJam earned 2000 total points
ID: 41777904
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
 

Author Closing Comment

by:LuckyLucks
ID: 41786509
thx
0
 
LVL 27

Expert Comment

by:ProfessorJimJam
ID: 41786513
you are welcome.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question