How to create columns for next 5 years with quarters from now in alteryx?

[AYESHASIDIKHA]

Hi,

I have a column name 2023 Year. I wanted to create the columns for the next 5 years along with quarters.

For Example: I have 2023 Year column name. Now Total year= Q3 2023(Current Quarter)+Q4 2023+Q1 2024+....+Q42028(Next 5 year quarters)

[FinnCharlton]

Hi @AYESHASIDIKHA , I would approach it like this:

Use generate rows to make year and month combinations for the next 5 years, and then use the CrossTab tool to turn these rows into columns. Workflow attached

[Christina_H]

It's not clear what data you're putting in, but here's a process that will create columns for 20 quarters starting from the current quarter.

[Luke_C]

Hi @AYESHASIDIKHA 

Here's a way with the generate rows, you could then cross tab or append your data: