Merging/Concat data in two columns to create a new vlaue

[Deano478]

Hi Folks,

I have a situation where I have data like so:

Servlice Line	Sub Service Line
Operations	Software Systems

I need to essentially merge the data in those two columns to create a new column that would look like this:

Servlice Line	Sub Service Line	Department
Operations	Software Systems	Operations - Software Systems

The other two columns must also remain as they are I have been banging my head off a wall over this and it sound so simple.

Cheers for any help in advance.

[Raj]

use the formula tool for this

[Raj · Accepted solution]

pfa

[Deano478]

@Raj wow I was really overthinking it cheers for that 

[Deano478]

@Raj sorry one more questions how would I get a space before and after the - ? 

[Raj]

@Deano478  use this

[Servlice Line]+" - "+[Sub Service Line]

or you can use

[Servlice Line]+" "+"-"+" "+[Sub Service Line]

both will work