Assign same number of elements to the column data based on number of elements (each row) of the other column

Hi all, I have two column data (Please refer to the attached) where first column contains "Number of Elements" and the second column contains "Stages" data. I want to assign the same number of data elements of "Stages" data to the new column ("Required") column based on the "Number of Elements" (first column) data. Any help in this regard is highly appreciated. I have included sample data as well.

Note: Desired data does not exist and I want it to be created as third column. I need the third column result based on first two column data.

Answer 1

[Walter Roberson]

This code creates the desired data.

I notice that the desired data already appears to exist inside the file -- though it might perhaps need to be converted from character. Is the actual requirement to convert the existing file, or is it to generate new output without reference to that existing column?

filename = 'https://www.mathworks.com/matlabcentral/answers/uploaded_files/952839/Sample_Data.xlsx';
T = readtable(filename, 'VariableNamingRule', 'preserve');
R = rowfun(@(NE, S) {repmat(S, 1, NE)}, T, 'InputVariables', 1:2, 'SeparateInputs', true, 'OutputFormat', 'table', 'OutputVariableName', 'Required')

R = 20×1 table
           Required        
    _______________________

    {[                0 0]}
    {[                  0]}
    {[                  0]}
    {[                1 1]}
    {[                  1]}
    {[                  2]}
    {[          2 2 2 2 2]}
    {[2 2 2 2 2 2 2 2 2 2]}
    {[2 2 2 2 2 2 2 2 2 2]}
    {[                3 3]}
    {[        0 0 0 0 0 0]}
    {[                3 3]}
    {[                  3]}
    {[  1 1 1 1 1 1 1 1 1]}
    {[1 1 1 1 1 1 1 1 1 1]}
    {[              1 1 1]}

[Ganesh Naik]

Hi Walter, thanks. Desired data does not exist and I want it to be created as third column. I should have made it clear earlier, sorry about it. I need the third column result based on first two column data. I have edited the same info in the orignal question. Thanks