How to merge two columns and keep one value if value matches in both columns

[sjkamstrup]

I need assistance with merging two columns and keeping the value if the value is identical in both columns. Please see picture below.

So in the new column it would look like:

12/15/2023

24.10.2019

24.10.2019

24.10.2019

Instead of:

12/15/202312/15/2023

24.10.2019

24.10.2019

24.10.2019

24.10.2019

Hope you can help!

[mangaus1111]

Please clarify your expected result

[JorgePinho · Accepted solution]

You can add a conditional column with a condition like this:

If Launch Date = Present to Market Date then Launch Date

If Present to Market Date = null then Launch Date

After that you can delete both columns and only keep the conditional one.