How to find the given index values in a array?

1 view (last 30 days)
I have a matrix having 17 rows and 41 colums (find the attachment)
How to find the values at the top from 2nd column to last column with respect to the first column corresponing values

Accepted Answer

Andrei Bobrov
Andrei Bobrov on 25 Apr 2019
in R2016b
T = readtable('Sheet2.xls','ReadVariableNames',0);
lo = T{:,2:end} ~= 0 & ~isnan(T{:,2:end});
[ii,~] = find(lo);
out = sortrows([T{:,2:end}(lo),T{:,1}(ii)],2);

More Answers (0)

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by