replace null values with content from another column based on condition

[Anonymous]

hi everyone,

i have a problem with replacing null values with content from other column. The scenerio is something like this. let say i have three columns A,B,C

A	B	C
X	10	10
X.1	null	10
X.2	null	10
Y	11	11
Y.1	null	11
Y.2	null	11

C is my custom column created based on data from two columns A and B. please help with the query to construct above scenario.

Thanks,

Sivaaprataap.

[MarcelBeug · Accepted solution]

On "Add Column"  tab duplicate column B to C

On "Transform" tab select column C, then option "Fill" - "Fill Down".

Looks like Column A is not required to determine the values in column C.

[Anonymous]

Hi Marcel,

Thanks for the help. It means a lot.

Regards,

Sivapratap