I need to group-by a couple of columns, so is there any component with which I can achieve this?
What I need is that the column 2 has values that can be added/removed dynamically. So, is there any component which can solve this problem of adding/removing rows and columns under column 2 dynamically.
Thanks in advance.
You can create a structure with the fields you're interested in getting from the database and create an Advanced Query that has that structure as output.
In the Advanced Query's SQL you can specify your group by clauses like you would do with SQL.