Remove Rows or Fill Down functions don't work

[DmitryC]

Got a dataset where I need to remove empty rows and then fill down columns but none of these functions work. A new step is added but nothing happens to the dataset in the Power Query Editor. Do you know how I can fix this?

[DmitryC]

Thank you.

I guess the query editor removes blank rows when all columns are empty in that row and not only the ones highlighted. 

[HotChilli]

Fill Down/Up works on null entries not empty or spaces.

https://learn.microsoft.com/en-us/power-query/fill-values-column