Help needed to auto create monthly columns from quarterly columns

[charlenemx1022]

Hello,

I am looking for an easier way to create 12 new monthly amount columns from 4 quarterly amount quarters (equally division) without having to manually using 12 formula tools. Thanks!

[binu_acs]

@charlenemx1022 can you provide more information or sample input and output for better understanding?

[charlenemx1022]

Sorry about that. Yes. I have Q1,Q2,Q3 and Q4 columns and I would like to create 12 new monthly columns for Jan-Dec with the monthly amount (Quarter amount /3) without having to use 12 formula tools. Thanks! 

[binu_acs · Accepted solution]

@charlenemx1022 one way of doing this

[charlenemx1022]

Thanks so much!

[charlenemx1022]

Is that a reason why you used a Dynamic Select instead of a Select? 

[binu_acs]

It is more dynamic than select tool