How to Merge the cells and name?

I have the data and I would like to name and merge.The above table the data i have, the below table the table i required.

[Walter Roberson]

How does this differ from the previous similar questions you have posted on the topic?

Answer 1

[Chunru]

datayouhave = rand(8, 5);   % replace this with your data
t = array2table(datayouhave, "VariableNames", ["Maths", "Physics", "Politics", "Economy", "English"]);
name = ["AAA", "AAA", "AAA", "BBB", "BBB", "BBB", "CCC", "CCC"]';
t = [array2table(name) t];
t

t = 8×6 table
    name      Maths     Physics    Politics    Economy      English 
    _____    _______    _______    ________    ________    _________

    "AAA"    0.12481     0.4245    0.89831      0.22978    0.0087086
    "AAA"    0.19179    0.89669    0.25311      0.16138      0.49893
    "AAA"    0.60817    0.29709    0.65617      0.49247      0.79378
    "BBB"    0.18862    0.49918    0.19054     0.047833       0.3502
    "BBB"    0.48838    0.55171    0.51338     0.066283      0.39933
    "BBB"    0.43513    0.48865    0.21088      0.21244      0.88148
    "CCC"    0.25775    0.61049    0.75696      0.80927      0.74499
    "CCC"    0.64411    0.27928    0.11384      0.13664      0.14539

[C PRASAD]

Thanks for theResponse but iam getting error "t = array2table(datayouhave, "VariableNames", ["Maths", "Physics", "Politics", "Economy", "English"]);"

Error using table.init (line 380)

The VariableNames property must be a cell array, with each element containing one

nonempty character vector.

[Walter Roberson]

Which MATLAB version are you using?

Try

datayouhave = rand(8, 5);   % replace this with your data
t = array2table(datayouhave, 'VariableNames', {'Maths', 'Physics', 'Politics', 'Economy', 'English'});
name = {'AAA', 'AAA', 'AAA', 'BBB', 'BBB', 'BBB', 'CCC', 'CCC'}.';
t = [array2table(name) t];
t

t = 8×6 table
     name       Maths      Physics     Politics     Economy     English 
    _______    ________    ________    ________    _________    ________

    {'AAA'}    0.057449     0.99295     0.93589      0.88883     0.54624
    {'AAA'}     0.20587      0.3941    0.058401      0.93182     0.29469
    {'AAA'}      0.6748     0.18482     0.71994      0.48408     0.84695
    {'BBB'}     0.51505     0.60256     0.21766      0.99488     0.17571
    {'BBB'}     0.32222     0.16554    0.039902      0.64758     0.82738
    {'BBB'}     0.95771    0.056249     0.86953      0.94728    0.085409
    {'CCC'}     0.82799     0.75418     0.95384    0.0025524     0.52635
    {'CCC'}     0.72661     0.97953     0.73226      0.92357     0.97658

[C PRASAD]

Thank you

Answer 2

[Walter Roberson]

You cannot create that kind of table in MATLAB.

In order to have a row name span multiple rows, you will need to create a table with three rows and two variables. The first variable will be the Name. For each row, the second variable must be a complete table.

M = round(randn(15, 5), 1)

M = 15×5

-0.2000 -0.5000 -0.1000 -0.9000 1.6000 2.0000 0.5000 0.6000 1.1000 -0.1000 0.4000 1.1000 -0.7000 -1.1000 1.0000 0.1000 0.5000 2.1000 0.8000 -0.4000 0.7000 1.1000 0.5000 -0.4000 1.1000 -0.4000 -0.4000 0.8000 1.5000 -0.7000 -0.7000 -0.2000 0.6000 0.4000 0.6000 0 0.7000 -0.3000 -0.4000 -0.6000 -0.9000 -1.3000 -2.0000 2.4000 -2.2000 -0.4000 -0.6000 -0.7000 1.1000 1.1000

varnames = ["Maths", "Physics", "Politics", "Economy", "English"];
T1 = array2table(M(1:5,:), 'VariableNames', varnames);
T2 = array2table(M(6:10,:), 'VariableNames', varnames);
T3 = array2table(M(11:15,:), 'VariableNames', varnames);
names = ["Ramu"; "Rihith"; "Swarmy"];

Output = table('Size', [3 2], 'VariableTypes', ["string", "table"], 'VariableNames', ["Name"; "Marks"]);
Output.Name = names;
Output.Marks = {T1; T2; T3};

Output

Output = 3×2 table
      Name         Marks   
    ________    ___________

    "Ramu"      {5×5 table}
    "Rihith"    {5×5 table}
    "Swarmy"    {5×5 table}

Output.Marks{1}

ans = 5×5 table
    Maths    Physics    Politics    Economy    English
    _____    _______    ________    _______    _______

    -0.2      -0.5        -0.1       -0.9        1.6  
       2       0.5         0.6        1.1       -0.1  
     0.4       1.1        -0.7       -1.1          1  
     0.1       0.5         2.1        0.8       -0.4  
     0.7       1.1         0.5       -0.4        1.1  

So you can construct the table, but it will not display nicely.