Data Validation

[vijaylnyadav]

Consider the following data,

Roll Number	Performance
1	Good
2	Average
3	Bad
4	Average
5	Good
6	Good
7	Bad
8	Bad
9	Average
10	Average

Condition:

I want to group the data according to the performance

e.g.: All the good in one, bad in one and Average in one like the below result which i wanted

Performance	Roll No
Good	1 5 6
Average	2 4 9 10
Bad	3 7 8

Please suggest some workflow.

Thanks 

[joshuaburkhow]

You can simply do this using only the Summarize tool with concat function and "\n" as the delimiter 

[vijaylnyadav]

HI @Qiu can you help me.

After running the workflow the output which I am getting is roll number continues.

whereas as per your image shown it is showing in next line (\n).

But I am not getting the roll numbers in next line but I am getting roll numbers in continues without any break.

[Qiu · Accepted solution]

@vijaylnyadav 

It works just finr on my end. I have modified the output path to relative and can you just simply run it anc check?

And I have also taken the advice from @joshuaburkhow , demonstrate how to use Summarize tool.