How do you group data in a table by multiple columns?

[qlikclack]

I have a data set that contains a buyer and a seller. I want to group my table such that each group contains all the information on projects they were buyer or seller. I also want to be able to filter projects where they were both a buyer or seller. I'd also only like to include projects where they were both a buyer and seller meaning each group should have a minimum of 2 projects but can have more. I've attached an imagine of what I would want my table to look like from another software. 

[Sebastian_Dec]

You can use pivot table to do that and define Dimensions (Row and Column) and Measures (Values).

Row will be Name (if you want You can not set Column).

Another path is to make a separate table for each "name" and limit the scope to only that value in Edit expression

[qlikclack]

The problem I am having is that I want it to filter on the Buyer or Seller. Currently it pulls the projects where the buyer = seller. I want one project where they are buyer and one where they are seller at minimum. It can be more than 2 but it needs at minimum one project buyer and one project seller. 

[Sebastian_Dec · Accepted solution]

OK now I understand. As far as I know, this cannot be done in Qlik.

In Pivot u will have like this (its require measures) :

In Table it look better:

[qlikclack]

Thank you for attempting to solve it. I was just curious to see if it could be solved within Qlik.