Remove PivotTable Duplicate Row Labels

[tdsmith14]

Hello,

Attached is a copy of a worksheet that I am currently working on. I have created a PivotTable, but can't figure out where the year 2014 totals are splitting up between 2 columns rather than just totaling in one column.


Thank you.

TC

[tdsmith14]

NOTE

I didn't meant to attach two copies of the workbook. The correct workbook I am referring to is the one with file size 755.9 KB.

Thank you.

[cbatrody]

Hi,

Please check the attached file. It's fine now.

Regards,
Chandra

Note: If you liked my answer, please click on the * button which is in the left side bottom of my answer window

[tdsmith14]

If you don't mind could you explain to me what the issue was and what you did to fix it, as I have more data to add, and incase I have the same issue another time?

Also another issue I'm having with the PivotTable is that vendor names listed in Column A are duplicating some of them.

[cbatrody]

Sometimes when the cells are stored in different formats within the same column in the raw data, they get duplicated. Also, if there is space/s at the beginning or at the end of these fields, when you filter them out they look the same, however, when you plot a Pivot Table, they appear as separate headers. The best solution here is to filter that field out in the raw data, select a cell which has the issue, copy and paste it across the column.

And for the Vendor Name issue, you can use the same solution.

Hope this clarifies..

Regards,
Chandra


Please click on the 'Add Reputation' button at the bottom of my post if I was helpful in resolving the issue.

[tdsmith14]

Thank you both for your help with this.

TC