![enter image description here](https://i.stack.imgur.com/STdke.png)

I need this for my school project a query that i cannot create.

the table contains 4 columns: 

`document id`, `party_id`, `full name`, `party role`.

And for a `doc_id` i have 2 rows, 1 for the `grantor` 1 for the `grantee`.
I want to make s single row but i did not succeed with case when.
Please help.

```
SELECT document_id, 
       case  when party_role ='grantor' then full_name 
       case  when party_role ='grantee' then full_name  
from sales.all_sales

```