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

2 views (last 30 days)
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

Accepted Answer

Bhaskar R
Bhaskar R on 27 Jan 2020
T.Lettersnumbers = strcat(char(T.Letters), num2str(T.Numbers));

More Answers (1)

Walter Roberson
Walter Roberson on 27 Jan 2020
T.Lettersnumbers = string(T.Letters) + T.Numbers;

Categories

Find more on Categorical Arrays in Help Center and File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!