Excel Report, Chance the name of headers

[neromerob]

Hello.

I´m working on a Report in which I have to sum values per month, something like this.

But what I need is the header to be like 2021_3, 2021_4 and so on. Considering that is a monthly report and will always be a new month in the Report.

Thank you in advance.

[DataNath]

@neromerob how does this look? It creates the necessary header from the old header itself so will always be dynamic. If it's not always 'CountWithNulls_' at the start then let me know and I can edit the formula.

EDIT: Have just made it dynamic anyway, assuming that it's always <letters>_ at the start.

[binuacs · Accepted solution]

@neromerob Another way of doing this with the replace function

[neromerob · Accepted solution]

Muchas gracias por la solución.