Replacing year from previous to current

[kauser]

Hello, 

how can i replace column heading from previous year to current year 

Input Data 

Item

Location

2024

Output Data 

Item

Location

2025

Thank you 

Kauser 

[Hsandness]

Hi @kauser ,

You can use the Dynamic Rename tool to find any column that is equal to the prior year and if it is, update it to the current year. If you don't need to by dynamic you could just use the Select tool.