Merging two columns with only rules on what to keep

Hi, Is it possible to merge columns 4 and 5 with it keeping what is in column 5 first and what is in column 4 if there is “no match” in column 5? I don’t want to merge all the information in both columns, only what is in column 5 then column 4 if there is no match. I hope I explain that correctly.

Thank you

@Kim Yes, you can do this with an If transform.


Ps/ Check has header on the input or use the Header transfrom to make the first row into column headers.

1 Like