PivotTables - Automatically Repeat Row Line

[DaRTH KiRo]

I have two PivotTable fields in the row section, seen below, I need the Trading Partner field to repeat next to the Transaction Set field on the entire pivot table. Below is also an example of what I am looking for. Is there a way to do this automatically so I do not have to do this by hand?

What I Get:

What I Need:

Please and thank you!

 

[sandy666]

maybe
Pivot Table Tools - Design

• - subtotals OFF
• - Report layout - Table form
• - Repeat all item labels

Analyze

• +/- buttons - hide

 

[DaRTH KiRo]

maybe
Pivot Table Tools - Design

• - subtotals OFF
• - Report layout - Table form
• - Repeat all item labels

Analyze

• +/- buttons - hide

That worked perfectly! Thank you very much

 

[sandy666]

You are welcome
Thanks for the feedback