Remove empty rows from cell array

Hi, I have a cell array (attached) and would need to remove the rows with "" as they are empty fields, but still keep the rows with a 0. Is there a way I can do that and convert this cell array to a matrix? Currently, there is an error with i use cell2mat(A) as the fields are not the same data type.

Thank you! Appreciate any help

[KSSV]

Check the data properly.....all cells are not numbers..one cell has a structure.

iwant = cell2mat(A(1:65))

The above gives column matrix.

[Cside]

Hi, how could i clean that up to return a 359 x1 column matrix? and thereafter remove the missing rows? thanks!

Answer 1

[Mario Malic]

To replace string fields

idx = cellfun(@isstring, A);
A(idx) = {0};

After this, you can use

A = cell2mat(A)

[Cside]

lovely, thank you!