Merging two columns into one to remove blank cells & duplications

[LucyR]

Hi,

Can someone please advise how to merge first two columns (Fund code and Fund code#) into one?

Thanks a mil!

Lucy

[Thableaus · Accepted solution]

Hi @LucyR 

You can use the Formula Tool to do that.

Create a New Column - 

IF IsEmpty(Fund Code) and !IsEmpty(Fund Code #) THEN Fund Code #

ELSEIF IsEmpty(Fund Code #) and !IsEmpty(Fund Code) THEN Fund Code

ELSE Fund Code ENDIF 

Drop the two old columns with the Select Tool.

Cheers,

[LucyR · Accepted solution]

Hi,

Thanks for your response but it doesn't seem to be working. Please see below and advise. Thanks a mil

[GiuseppeC · Accepted solution]

Hi @LucyR,

all field names in your expression should be enclosed in square brackets (i.e. [Fund Code] rather than Fund Code).

Hope this helps,

Giuseppe

[Thableaus · Accepted solution]

@LucyR 

I mistyped the second else, it should be ELSEIF

Also, add the brackets as @GiuseppeC  mentioned

IF IsEmpty([Fund Code]) and !IsEmpty([Fund Code #]) THEN [Fund Code #]

ELSEIF IsEmpty([Fund Code #]) and !IsEmpty([Fund Code]) THEN [Fund Code]

ELSE [Fund Code] ENDIF

Cheers,

[LucyR]

It is still not working. Please see below

[LucyR]

@Thableaus

I fixed ELSEIF formula and it isn't working. Please see below

[Thableaus · Accepted solution]

@LucyR 

You forgot to add parenthesis between the fields.

Copy and paste this expression

IF IsEmpty([Fund Code]) and !IsEmpty([Fund Code #]) THEN [Fund Code #]

ELSEIF IsEmpty([Fund Code #]) and !IsEmpty([Fund Code]) THEN [Fund Code]

ELSE [Fund Code] ENDIF

Cheers,