How can I generate a new cell with only column 1,2 and 8 not by merging
ca = {'Col1','Col2','Col3','Col4','Col5','Col6','Col7','Col8','Col9';
'1', 70 , 80 , 100, 99, 99, 95, 95, 95;
'2', 30 , 90, 95, 90, 95, 99, 95, 95;
'3', 100, 70, 85, 90, 95, 99, 95, 95;
'4', 100, 70, 85, 90, 95, 99, 95, 95;
'5', 100, 70, 85, 90, 95, 99, 95, 95;
'6', 100, 70, 85, 90, 95, 99, 95, 95;
}
partA = ca(:, 1:2)
partB = ca(:, 8)
newca = [partA,partB]
You can simply reference all of the columns you need in one indexing array, instead of treating columns 1/2 and 8 seperately. So
newca = ca( :, [1,2,8] );