How do I concatenate some rows to new one including character with JMP formula?

[#1]

I want to concatenate some rows to new one as below.

Column X, Column Y

--> New Column : Column X_Column Y

Can I use JMP formula to merge like this?

One additional question is when I add new column based on some formula, can I take JMP script for the data table containing formula column?

[#2 · Accepted solution]

You can simplily create a new character column, and use the following formula to concatenate you columns into the new column.

char(:columnX) || "_" || char(:columY)

You need to read the Using JMP documentation

     Help==>Books==>Using JMP