General Discussions

Discuss any topics that are not product-specific here.

Getting alteryx to add all 12 months for each year listed

Destinitruth
6 - Meteoroid

Hello, 

 

If I a spreadsheet with a list of years in one column, and I want to mirror the rows but instead of the year being reflected, I want to add  months for each year. So if I have 

2022

2023

2024

2025

 

I need it to have 

2022 Jan 

2022 Feb

2022 Mar 

 

2023 jan 

2023 feb 

2023 mar 

etc... 

 

I cant seem to figure out a robust way to add the months to each year in my data. 

2 REPLIES 2
binuacs
21 - Polaris

@Destinitruth one way of doing this with the help of generate row tool

image.png

Destinitruth
6 - Meteoroid

Thank you so much ! 100% solved my issue!

Labels
Top Solution Authors