Forum Discussion

RAM KUMAR LAKKOJU's avatar
RAM KUMAR LAKKOJU
Copper Contributor
Oct 28, 2019

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.  
Power Query
JKPieterse's avatar
JKPieterse
Silver Contributor
Oct 28, 2019
I expect it is because the rows that appear to be blank in reality are not blank?
  • juan jimenez's avatar
    juan jimenez
    Iron Contributor
    Apr 20, 2020

    JKPieterse 

     

    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

    • JKPieterse's avatar
      JKPieterse
      Silver Contributor
      Apr 21, 2020
      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).

Resources