how to group rows by date

i have this data
i want to group\sort them to be something like this:
how i can do this ?

 Risposta accettata

Andrei Bobrov
Andrei Bobrov il 23 Mag 2015
Modificato: Andrei Bobrov il 23 Mag 2015
[~,~,z] = xlsread('20150523.xlsx');
c = z(cellfun('isempty',regexp(z,'\')));
[y,~] = datevec(c);
[~,~,c0] = unique(y);
c1 = accumarray(c0,(1:numel(c0))',[],@(ii){c(ii)});
c2 = [c1,repmat({{[]}},size(c1))]';
out = cat(1,c2{1:end-1});
xlswrite('20150523.xlsx',out,1,'B1')

3 Commenti

Amr Hashem
Amr Hashem il 23 Mag 2015
it works...thanks
Andrei Bobrov
Andrei Bobrov il 23 Mag 2015
corrected
Amr Hashem
Amr Hashem il 24 Ago 2015
Thanks... its amazing

Accedi per commentare.

Più risposte (0)

Categorie

Community Treasure Hunt

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

Start Hunting!

Translated by