Quarterly to monthly time series

[Tommy]

Hi

I have found a lot on aggregating monthly time series to quarterly. However I am trying to go in the other direction with seasonality by month included. Is there one formula which can be applied to achieve this?

Please see attached file.

Thanks

[teylyn]

Hi Tommy,

With the data layout of the attached file, try in C14 and copy to the right

=INDEX($C$5:$J$5,MATCH(C10,$C$2:$J$2,0))*C12

cheers