How to merge data in excel files?

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.

Answer 1

[Iman Ansari]

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

[shazwani amran]

 Hi, how if the data was like below. is it possible for me to merge them? 

 5    5    5   8     7    7    9    9    9 .....(and so on)
1.2           4.4             7.1
     2.5            5.2            5.5
          3.9            6.5            4.3
after importing the excel file that contained data like above, the data need to be merge according to the first row which have same value to become like this:

5      8     7     9
1.2   4.4         7.1
2.5         5.2   5.5
3.9         6.5   4.3

[Iman Ansari]

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