Multi level sorting and filtering

6 views (last 30 days)
Mekala balaji
Mekala balaji on 17 Jan 2015
Commented: Mekala balaji on 17 Jan 2015
I have original data in Table1 and want to do multilevel sorting and filtering to remove repeated data and finally get unique data as in Table2. Please some one help me how to get Table2 data from Table1.
My sincere thanks in advance, Mekala

Answers (1)

Shoaibur Rahman
Shoaibur Rahman on 17 Jan 2015
Edited: Shoaibur Rahman on 17 Jan 2015
[~, ~, D] = xlsread('Multilevel_sorting.xlsx');
A = D(3:end,1:2); % your data in table 1
G = {'Group1','Group2','Group3','Group4','Group5'};
for k = 1:numel(G)
B{k} = A(strcmp(A(:,2),G(k)));
B{k} = [G(k); unique(B{k})]; % remove G(k) if you don't need the Group headers
B is your table 2. To see the elements in B, just type B{1} for Group1, B{2} for Group2 and so on.
  1 Comment
Mekala balaji
Mekala balaji on 17 Jan 2015
I do not want to define the groups (assuming it is unknown). I Want write code to filter by uniqueness, and then I want store under each unique cell in column2 in table1, how many unique cells are present in column1.
Sincerely, Mekala

Sign in to comment.


Find more on Licensing on Cloud Platforms in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by