How to merge data in excel files?
3 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
below is sample data from an excel file that I need to merge.
1 1 1 2 3 3 4 4 4
1.2 4.4 7.1
2.5 5.2 5.5
3.9 6.5 4.3
the above data need to be merge according to the first row which have same value to become like this:
1 2 3 4
1.2 4.4 7.1
2.5 5.2 5.5
3.9 6.5 4.3
I'm really appreciate someone that can help me.thank you.
0 commentaires
Réponses (1)
Iman Ansari
le 9 Avr 2013
Modifié(e) : Iman Ansari
le 9 Avr 2013
Hi
Data=xlsread('name.xlsx');
Data(isnan(Data))=0;
for i=1:4
Output(:,i)=[i; sum(Data([false true true true],Data(1,:)==i),2)];
end
2 commentaires
Iman Ansari
le 21 Avr 2013
clear
Data=xlsread('name.xlsx');
Data(isnan(Data))=0;
n=nnz(diff(Data(1,:),1,2))+1;
Idx=[1 find(diff(Data(1,:),1,2))+1];
for i=1:n
Output(:,i)=[Data(1,Idx(i)); sum(Data(2:4,Data(1,:)==Data(1,Idx(i))),2)];
end
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!