Hi Folks,

I'm struggling with this one! I need a formula that can automatically populate yearly quarters in separate columns based on a number of years.
So if I put in 5 years - excel would populate 20 columns with Quarter 1 - Quarter 2 and so on. If I then change it to 3 years it would only populate 12 columns.

Is there a way to do this somehow?

Thank you so much!