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

6 Replies

  • 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