concatenation of a a new column based on two previous columns

[Masond3]

Team, 

I need your help 

I have two columns called :

• Status 1
• Status 2 

I would like to produce a new column called "Status 3",  Status 3 should be the overall concatenation of the values in  "Status 1" with the values in "Status 2"  (expect where status 1 has the value of "Inactive")

NB : 

Status 1 - Can have a single value, or multiple values
Status 2  - Will always have a single value of "Ops

Desired output 

Status 1	Status 2	Status 3
Inactive	Ops	Ops
Digital	Ops	Digital;Ops
Digital;Sales;	Ops	Digital;Sales;Opps
Client;Digital;Sales	Ops	Client;Digital;Sales;Ops

The way i have tacked it is as follows ;

Formula 1  : IF [status 1] = "Inactive" THEN "Ops" else [status 1 ] ENDIF

Filter : Filtering out those records that have status 1 = Ops
Formula 2  [status 1 ]+ ";" +[status 2]



Regards
Masond3

[ChrisTX · Accepted solution]

Use a Formula tool to create the new field Status 3:

IF [Status 1] = "Inactive" THEN [Status 2]

ELSE [Status 1] + ";" + [Status 2]

ENDIF

Chris