How to show data in the same row instead of duplicating row data for different field values

[Anin]

Hi, I have a master table for my dashboard. It has ID, Activity_name, and UserName.
Each ID  has  multiple activity and as per the activity, the username will differ :
For example :

ID	Activity_Name	Username
1	Request	Adam
1	Approve	Jill
2	Reject	Nathan
2	Approve	Bill
2	Request	Nolan
3	Request	Ajax
3	Approve	Ronald
3	Reject	Kevin

In my table,  I need to have the request - username and show the Approve( if applicable) username in the same row : 

ID	Request	Approve
2	Nolan	Bill

However, It is coming in a separate row, data getting duplicated which is incorrect :

ID	Request	Approve
2	Nolan	-
2	-	Bill

This is what I have used in the expression for approve and Request  : =

if(match(ACTIVITY_NAME, 'Approve'), USERNAME)

if(match(ACTIVITY_NAME,'Request'), USERNAME

Kindly support, How can I show both the data in the same row, without duplicating the rows?
Thanks 

[Or · Accepted solution]

Dimension: ID

Measures:

Only({< Activity_Name = {'Approve'} >}Username)

Only({< Activity_Name = {'Request'} >} Username)