How to concatenate two columns in one table into one column?

Hi,

I have a table of 5 columns with strings, I would like to concatenate the two columns by a "_" and make them into one column.

Table A:

var1 var2 var3 var4 var5 ABC 123 aaa bbb ccc EFG 345 ddd eee fff into B: var1 ABC_123 EFG_345

How to do that?

Thanks.

Jennifer

[JFz]

In addition, in the var2, there are some string like 'N/A'. I want to replace 'N/A' by just nothing ''.

Thanks for any help.

Jennifer

Answer 1

[JFz]

Actually I did it with t.Var1 = strcat(t.Var1, '_', t.Var2)

Answer 2

[Varun Bhaskar]

Hi,

It is not possible to concatenate two columns after the table has been constructed. You can concatenate the two columns prior to constructing the table using the 'strcat' function.

[Peter Jarosi]

Eh,

It's not true. I tried JFz's idea for tables already been constructed. It works! At least in Matlab 2016a or later versions.