Oct 28 2019 05:43 AM
why power query is not responding to fill donw option? i want fill down in colunmn named "name".
Plz help me.
Oct 28 2019 06:09 AM
Apr 20 2020 11:49 AM
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
Apr 21 2020 01:47 AM
Apr 21 2020 03:21 AM
Thank you for your help. unfortunately I was not able to fill down.
Can you look the attached file and help me?
Apr 21 2020 05:37 AM - edited Apr 21 2020 05:37 AM
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.