Normalizing Quarterly Data to Monthly Data

cjsnets10

Hi Alteryx Community,

I have a dataset that based on the product depends on the frequency of when the data comes in. Product A has data come in on a monthly basis and Product B comes in on a quarterly basis. I want to normalize the count of Product B to come in on a monthly basis and to spread out evenly based on the quarter. For example Product B Q1 2021 had a count of 99. I want the 99 count to be spread out 33 for Jan 2021, 33 for Feb 2021, and 33 for March 2021.

How Data Comes in					How I want it
Product	Date	Count				Product	Date	Count
Product A	1/31/2021	23				Product A	1/31/2021	23
Product A	2/28/2021	43				Product A	2/28/2021	43
Product A	3/31/2021	54				Product A	3/31/2021	54
Product A	4/30/2021	25				Product A	4/30/2021	25
Product A	5/31/2021	243				Product A	5/31/2021	243
Product A	6/30/2021	53				Product A	6/30/2021	53
Product A	7/31/2021	56				Product A	7/31/2021	56
Product A	8/31/2021	7				Product A	8/31/2021	7
Product A	9/30/2021	4				Product A	9/30/2021	4
Product A	10/31/2021	324				Product A	10/31/2021	324
Product A	11/30/2021	345				Product A	11/30/2021	345
Product A	12/21/2021	786				Product A	12/21/2021	786
Product B	3/31/2021	99				Product B	1/31/2021	33
Product B	6/30/2021	300				Product B	2/28/2021	33
Product B	9/30/2021	400				Product B	3/31/2021	33
Product B	12/21/2021	900				Product B	4/30/2021	100
						Product B	5/31/2021	100
						Product B	6/30/2021	100
						Product B	7/31/2021	125
						Product B	8/31/2021	125
						Product B	9/30/2021	125
						Product B	10/31/2021	300
						Product B	11/30/2021	300
						Product B	12/21/2021	300

Felipe_Ribeir0

Hi @cjsnets10 

Please see if it is this

Just this row i did not understand, it should become 3 rows of 133 count each right?

Product B

9/30/2021

400

If the provided answer helped you to solve the problem/was correct, please accept it as a solution

Thanks.

Normalizing Quarterly Data to Monthly Data.yxmd