how to group rows by date

2 次查看（过去 30 天）
Amr Hashem
Amr Hashem 2015-5-23
评论： Amr Hashem 2015-8-24
i have this data
i want to group\sort them to be something like this:
how i can do this ?

请先登录，再回答此问题。

采纳的回答

Andrei Bobrov
Andrei Bobrov 2015-5-23
编辑：Andrei Bobrov 2015-5-23
[~,~,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')

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Shifting and Sorting Matrices 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by