How do I fill sequential data while data cleansing?

[pbaba]

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

[AngelosPachis · Accepted solution]

Ηι @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

[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

[pbaba]

@AngelosPachis  Ignore. Just saw the GroupBy function in the Multi Row Formula tool. First time using the formula. Thank you for your assistance.