How do I fill sequential data while data cleansing?

I have a table that I need to fill sequential data to complete the table.

Product	Date	Medal
A	1-Jun	Bronze
A	1-Jul
A	1-Aug	Silver
A	1-Sep
A	1-Oct
A	1-Nov
A	1-Dec

Easy to do this in excel but looking for any ideas on how I can get the table to fall into this format.

Product	Date	Medal
A	1-Jun	Bronze
A	1-Jul	Bronze
A	1-Aug	Silver
A	1-Sep	Silver
A	1-Oct	Silver
A	1-Nov	Silver
A	1-Dec	Silver

Datasets

Accepted answers

AngelosPachis

Ηι @pbaba ,

In Alteryx you can do that with a multi-row formula tool and an IF statement checking if a current cell is null. If it is then grab the value from above, else leave the value in the cell

Hope that helps.

Cheers,

Angelos

example.yxmd

All comments

AngelosPachis

Ηι @pbaba ,

In Alteryx you can do that with a multi-row formula tool and an IF statement checking if a current cell is null. If it is then grab the value from above, else leave the value in the cell

Hope that helps.

Cheers,

Angelos

example.yxmd

pbaba

@AngelosPachis Thank you for your help. Is there a way to isolate another variable as such (additional product added):

Product	Date	Medal	Product	Date	Medal
A	1-Jun	Bronze	A	1-Jun	Bronze
A	1-Jul		A	1-Jul	Bronze
A	1-Aug	Silver	A	1-Aug	Silver
A	1-Sep		A	1-Sep	Silver
A	1-Oct		A	1-Oct	Silver
A	1-Nov		A	1-Nov	Silver
A	1-Dec		A	1-Dec	Silver
B	1-Jun	Gold	B	1-Jun	Gold
B	1-Jul		B	1-Jul	Gold
B	1-Aug		B	1-Aug	Gold
B	1-Sep		B	1-Sep	Gold
B	1-Oct	Platinum	B	1-Oct	Platinum
B	1-Nov		B	1-Nov	Platinum
B	1-Dec		B	1-Dec	Platinum

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703