Skip null and add next value?

[newbie43_]

 Hello,

 My "Child" looks like this:

Col1	Col2
Value 1a	null
null	Value 1b
Value 2a	null
null	Value 2b
Value 3a	null
null	Value 3b

and I need a solution to transform the table in that shape:

Col1	Col 2
Value 1a	Value 1b
Value 2a	Value 2b
Value 3a	Value 3b

Please Help me fellows, I'm desperate.

Thanks!

[CNENFRNL · Accepted solution]

Hi, @newbie43_ , take heart, my friend, it's easy, just fill down a column then fill out null in the other column.