Populate cell value to below x cells

[swain]

Hello community!

I'm really new in Power BI and ran into an issue that I can't figure out. I need to add month values to the column next to the QTY to be able to see qty of certain month. The data is coming from Sharepoint list where one of the columns is "Month". 

I was thinking if it was maybe possible to populate value of month name into next 8 cells somehow, because 8 cells is always a constant? So that there is month name in one cell and next eight cells in the column have the same month name as well. 

Thanks in advance!

[jthomson · Accepted solution]

Should be able to do this in a couple of steps - first I'd replace anything that says other with a null, and then you should be able to use Table.FillDown to get the result you want

[swain]

I can't belive it was simple as that. Thanks!