Categorization in a table

[LesJean]

Hello everyone,

So I have data in a table visualization and I'm trying to further categorize it inside "sub-sections". Lets say I currently have my data like this:

ID | Description | Sub-group 
1  | aaa         | 1
2  | bbb         | 1
3  | ccc         | 1
4  | ddd         | 2
5  | eee         | 2
6  | fff         | 3
7  | ggg         | 3

Is there any way to display my data in this way with Qlik Sense (be it with a table visualization or any other visualization that would enable me to do this) :

ID | Description
Sub-group 1
1  | aaa
2  | bbb
3  | ccc
Sub-group 2
4  | ddd
5  | eee
Sub-group 3
6  | fff
7  | ggg

Thank you guys very much,

LesJean

[y_grynechko · Accepted solution]

Hey, 

One of the solution would be to use pivot: