Transform data: Fill down for text columns

[BBECQ]

Hi,

When importing a csv file, as you see in the picture below, fill down for the data field functions perfectly ... 
For 3 columns on the right with text fields, it doesn't work. 



After importing the source file, the date fields that are empty show as 'null' where the text fields show nothing (blank). Is that playing a role? 

Anyone able to provide me a 'dummy proof' method I can use to make this work too? 
I wasn't able to apply the solutions proposed by Chat GPT... To difficult for my current skill level 😉

Thanks!!

[danextian · Accepted solution]

Hi @BBECQ 

The Fill Down function doesn't work on cells with white space or blank spaces—they are considered non-nulls and will be filled down as such. To resolve this, right-click a blank space cell, select "Replace Value," leave the first field empty, and enter "null" in the second field. Then, try filling down again.

[BBECQ]

yes!! So simple ... First tried to replace by "null" but had to type null and on my 2nd attempt it all filled down !!
Thanks!!!!!