I got this code at the moment. I converted my file to .xlsx so I can read my data in matlab. What the forloop does is it goes through the data and goes through cells that contains NaN value then deletes the entire row, resulting in no NaN values in the data set. However, in the end the columns that contained 'string' values turns to NaN value. How do I convert back those NaN values to string values again?
T = xlsread('testfile4.xlsx');
for col = 6:size(T,2)
i = find(isnan(T(:,col)));
T(i ,:) = ;
This is what it looks like after deleting the rows with NaN values. Now the second and third columns contains NaN values which was strings before.