Yes you can do it manually via the settings but need to be able to do it via office script.
add repeat item labels in a PivotTable office script

Oisín Liston
25
Reputation points
Can office scripts support adding repeating item labels in a PivotTable? When I try to record this action within Excel online it gives a error - activity cannot be recorded.
Are there plans to update office scripts to support this action?
I'm using office scripts with a pivot table to transpose and summarise data within a tab on an excel online file before converting the data to a table for input into a Power Automate flow.
As such I need all item labels to repeat for the table to populate correctly.