Forum Discussion
fill down in power query
why power query is not responding to fill donw option? i want fill down in colunmn named "name". Plz help me.
I expect it is because the rows that appear to be blank in reality are not blank?
hi Jan,
Does that mean that cells not "null" are not empty even they have no characters seen?
How could i erase the "invisible content"?
Thanks, Juan
- You could add a column which takes the length of the string in the column you are interested in and filter the query on non-zero length strings. Otherwise, check out the right-click menu when you right-click a column. Especially the Transform sub-menu gives some cleaning options. Finally you could do a search and replace for certain non-printing characters. Infamous characters causing problems are ASCII 160 (non-breaking space) ASCII 10, 12 and 13 (line feed, carriage return+linefeed, carriage return).
Thank you for your help. unfortunately I was not able to fill down.
Can you look the attached file and help me?
Filling down only works if the value is null. You'll need to select the name column, replace the blank ("") values with "null" (I couldn't use your example because the source data wasn't provided). Then fill down.
