How to merge data in excel files?
3 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentare
Antworten (1)
Iman Ansari
am 9 Apr. 2013
Bearbeitet: Iman Ansari
am 9 Apr. 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 Kommentare
Iman Ansari
am 21 Apr. 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
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!