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