CODEWITHSUNDEEP
excelformattingpivot-table
Sri Sreshtan
Sri Sreshtan

Reputation: 41

How to remove repeated values of a pivot table excel?

Below is the attached image of a pivot table.

Pivot Table unformatted

But the values of transaction amount is getting repeated twice.

Intended output:- Intended output

How to ensure that Name has a separate column and transaction amount is getting repeated only once?

Upvotes: 0

Views: 46

Answers (1)

Rory
Rory

Reputation: 34045

Change the layout to Tabular and turn off subtotals for the Description field.

Upvotes: 1

Related Questions