Display factors of a variable in one column by date.

[nezuko_kamado]

How can I input factors( a,b,c ) of a variable(Project) in one column by ActionDate in qlik like excel, or other programings?

 this is the data I used. 

test:
load ActionDate, if ( isnull(Project ),'Unknown', Project) as Project , Approval
Inline [ ActionDate, Project , Approval
2/4/2021, a , cancel
2/4/2021, b, approve
2/4/2021, c, approve
2/5/2021, b, cancel
2/5/2021, a, approve
2/5/2021,c,approve
2/8/2021, c, approve
2/10/2021, a, approve
2/10/2021, b, cancel
2/10/2021, c, approve
3/15/2021,a, approve
3/15/2021, c, cancel
];

[Kushal_Chawda · Accepted solution]

@nezuko_kamado  create a table with dimension ActionDate and below measure

=Concat(DISTINCT Project,',')