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 ?

 Accepted Answer

Andrei Bobrov
Andrei Bobrov on 23 May 2015
Edited: Andrei Bobrov on 23 May 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 Comments

it works...thanks
corrected
Thanks... its amazing

Sign in to comment.

More Answers (0)

Categories

Community Treasure Hunt

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

Start Hunting!