Forum Discussion
Remove Rows or Fill Down functions don't work
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?
2 Replies
Fill Down/Up works on null entries not empty or spaces.
https://learn.microsoft.com/en-us/power-query/fill-values-column
Thank you.
I guess the query editor removes blank rows when all columns are empty in that row and not only the ones highlighted.
