Merge Rows

[Jassim]

Hello,

I would like to merge tables, that have the exact same headers. Some value are filled in 1 raw and blank in another. I would like to have all filled values in the same raw. You can find in the screenshot an example, I would like to bring the "30" in the first raw (to be then able to delete the 2nd raw).

Thanks for your help!

PS: I tried the "Merge" function to then repatriate the value of the 2nd raw to my first raw in relevant cell, the issue is that when no raw exist, I have an "empty" input in merge function.

Key_Transaction	Status_201_30	Status_201_20
D0AZ13S000000001515		20​
D0AZ13S000000001515	30​

 

[DanielSZ]

The easiest way to do this is to use the calculator box to update the column "Status_201_30" and then, use the "selectColumn box to drop the "Status_201_20" column. Something like this :