Merge multiple column

I have few columns which I have combine with "-". As it visible in picture below.


The combination would look like

State highway-Section-Direction/rp

01N-0414-B/286

Let me know if require more details.

Hi Jigar and welcome to the Community!

You can use &, the text concatenation operator, in an expression to calculate a new column:

[State highway] & '-' & [Section] & '-' & [Direction] & '/' & [rp]

Also, if you haven't done it yet, see our tutorial articles on expressions:

1 Like