Duplicate 500 rows just changing the year

Question

I need to duplicate ~500 rows with the same values, just increasing the year - from 2026 to 2034.

The Region, Geo, Function, Salary, Child and Targets needs to be the same, just increasing the same information though the years.

Below one print to explain what I need.

Thank you so much!

alteryx help image.png

alexnajm · Accepted Answer

The Append Fields tool will be your best bet! Append the list of years to your data and sort the way you may need