Pivot Table - Row Label Combination

O

oetkena

In my source data have have two separate columns which contain the same type of data.

Column #1 is "Symptom 1" and contains data such as "Broken/Damaged", "Cosmetic", "Labeling - Incorrect".
Column #2 is "Symptom 2" and contains data such as "Broken/Damaged", "Cosmetic", "Labeling - Incorrect".

When I drag these two columns into the Row Labels on my pivot table the Column #2 is a subset of Column 1. Since they contain the same information, but for different non-conformances, I'd like to combine Column 1 and Column 2 into the same row label without subsets such that I can have a total amount of Symptom, whether it be Symptom 1 or Symptom 2.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format column widths from one table to a separate table on same page 1
How to combine two column labels in a pivot table 1
PivotTable - Filter Row 0
Pivot table put multiple "Values" in one row but I want them in one column. 0
Office 2007 Pivot Table Display format - Show row headings in each 1
07 Pivot Table side by side row labels 3
pivot table missing rows? 0
Random table of data - need to find every cell that contains specific data 1

Top