Need to turn table within cell to array

So I have a table within a table and would like to turn it into a column vecotor (displaying all individual data), I tried a couple of differetn function but that did not work

Answer 1

[Tushar Behera]

Hi David,

I believe you have a table which consists of several other tables. You want to convert one of those table into a vector array.

You can use "table2array" function in ordert o acheive the above functionality. For example:

% Define the table within a table
tableInTable = table({table(1:3, 'VariableNames', {'a'}); table(4:6, 'VariableNames', {'b'})},...
                     'VariableNames', {'NestedTable'});

% Convert the table within a table to a column vector
columnVector = table2array(tableInTable.NestedTable{1})

Hope this answers your query.

Regards,

Tushar

[David Chan]

columnVector = table2array(BCG_data_table_converted(1,1));

columnVector = cell2mat(columnVector);

I tried the above, the first line work, reurning a 1x1 cell, however, the second line does not work