MATLAB: Merge two table columns (column 1: categorical data; column 2: double el) into one (column 3: categorical or string el) and replace columns 1,2 with 3 in the table

merge columns in table

Dear All,
I have a table with 4 columns, column 1: T.Letters = A; BC, DEF, G, HI .. etc (categorical array)
column 2: T.Numbers = 1;2;3;4;1;2;1;2;3 .. etc (double array)
How can I combine columns 1 and 2 into column 3: T.Lettersnumbers = A1; BC2; DEF3; G4; HI1 .. (containing categorical or string elements 'HI1'),
then insert it into the table in lieu of columns 1 and 2.
Many thanks,
Vio

Best Answer

T.Lettersnumbers = strcat(char(T.Letters), num2str(T.Numbers));