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.
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).