Forum Discussion

newbie43_'s avatar
newbie43_
New Member
5 years ago
Solved

Skip null and add next value?

 Hello,

 My "Child" looks like this:

 

Col1Col2
Value 1anull
nullValue 1b
Value 2anull
nullValue 2b
Value 3anull
nullValue 3b

 

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

 

Col1Col 2
Value 1aValue 1b
Value 2aValue 2b
Value 3aValue 3b

 

Please Help me fellows, I'm desperate.

 

Thanks!

Need Help
  • CNENFRNL's avatar
    CNENFRNL
    5 years ago

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

1 Reply

  • CNENFRNL's avatar
    CNENFRNL
    Community Champion
    5 years ago

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