How to make for loop to count items in excel sheet?!

Hello every body;

i am having data listed in excel sheet contains 980 row and 30 column

Each row consists of zeroes and ones, I want to make a for loop to consider all ones adjacent to each row and name it by the number of each column. so finally i will have only one column that contains the different items correspond to 1 i.e --> Row1: [4,12,13,15,16,18,19,20,22,24,27]

can anyone help me to do such operation please??! Thanks A lot

[Mariam Sheha]

Hello could anyone answer this one please ?!

[dpb]

Not until we can understand what it is you're asking for, no...

Give a small sample, 2 or 3 rows with a half-dozen columns should be more than enough to illustrate. Paste the data and the desired results as code and how you get the latter from the former.

Answer 1

[Walter Roberson]

num = xlsread('Data1.xlsx');
result = arrayfun(@(ROW) find(num(ROW,:)), (1:size(num,1)).', 'Uniform', 0);

[Mariam Sheha]

It is awesome , Really i am very very thankful for your help...